AdventureWorks2008 database missing in SQL server 2008 samples installer
- i installed SQL server 2008 sample databases (refresh 2) twice on my machine and both the times AdventureWorks2008 database was missing. Anyone had same or similar problem. I appreciate your help!
Thanks, Praveenkumar Dayanithi MCTS (SQL Server 2005 BI)
All Replies
This isn't much information to go on. Be default, the AdventureWorks2008 installation process automatically downloads the database files (.mdf and .ldf) and attaches the databases to your local instance of SQL Server 2008. So, when you say the database is missing, one has to wonder whether you mean the databases do not appear in the Object Explorer of SQL Server Management Studio, or you cannot find the *.mdf and *.ldf files on your local machine.
Note that the AdventureWorks2008 database requires that full-text search and FILESTREAM is enabled on your instance of SQL Server. If they are not, the installation will fail.
Please read the "Database Prerequisites" and "Installing Databases" topics that are linked to from this location: http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=18407. Following the instructions in these topics should resolve your issue. If not, please report back.
Kind regards,
Gail
Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights- Sorry for the insufficient details...
Gail,
Actually both are true. I dont the see the database in object explorer and dont see the mdf and ldf files on my machine.
I enabled full-text search and FILESTREAM before installed the samples....
Thanks, Praveenkumar Dayanithi MCTS (SQL Server 2005 BI) Thanks for verifying that full-text and filestream are enabled. If you don't see anything in the SQL error logs during the time that you tried to install the samples, then I suggest that you try the installation again from this location: http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=18407.
Regards,
Gail
Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights- Gail,
I appreciate your help!
The link you sent is for Sample databases REFRESH 1 but i was having problems with REFRESH 2 found at below link...
http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=19353
Thanks, Praveenkumar Dayanithi MCTS (SQL Server 2005 BI) - I am really frustrated as well. I have installed SQL twice. I am missing all of the files for AdventureWorks2008 database. None of the files are located on my computer. I have all of the rest of the databases just not the one i need. Also after my second install of SQL I am now missing the reporting database. this is one of the worst products I have ever installed. How can I get these installed? I have everything enabled that needed to be prior to installation.
Thanks
Heather - One more thing. I am using Vista and This was working properly prior to a restart of my computer. When I opened up SQL my databases were gone. When I uninstalled reinstalled they are still not there.
- I've successfully installed Samples Refresh 3 on Vista x86 on SQL Server 2008. If you are still having trouble, please uninstall all previous versions, make sure your C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\ (or appropriate directory for your instance) does not have any sample databases in it, and then follow the instructions at http://support.microsoft.com/kb/314852 for enabling MSI logging, and try the install again. Attach the most recent msi log from %temp%\MSI*.log to a work item which you can file at http://msftdbprodsamples.codeplex.com/ and I'll look into it.
Alternatively, you can download the scripts from the zip file and try installing the databases from script. Please let me know what error message occurs when you run the scripts.
--Bonnie
Bonnie Feinberg [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights Hi,
I am using the Developer Edition of the SQL Server(to learn and create SSIS packages), I am trying to install adventureworks2008 DB.
When sql2008.adventureworks_all_databases.x86.msi is finished installing, I see all other DB installed except adventureworks2008.
The book I am learning from has all its exercises from adventureworks2008 OLTP database. Please help me install the adventureworks2008 database.
Also, it would be great if any of you tell me where I can get just the adventureworks2008.msi file....
Thanks,
Raghu- I am experiencing exactly the same problem as damaldimil above.
Does anyone know why this happens? Everything else is there except for AdventureWorks2008 OLTP DB.
I did not get any errors during installation or anything.
I also carefully verified that all installation requirements (ones that are mentioned in this thread) are satisfied.
I checked C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\ directory and all expected files are there except for ones related to AdventureWorks2008. - Just saw this thread and found where installscript was located for AdventureWorks2008 DB.
When I ran the script there manually, I got a bunch of errors there.. I'm going to fix these errors and see.
Hope this helps.
http://social.msdn.microsoft.com/Forums/en-US/sqlserversamples/thread/5634ae33-29b2-438e-8fff-f8c3d13094e9 I finally solved this mystery.
The problem was with MSSQL service permission.
After I ran the init script manually in sqlcmd mode (see my replies above), I narrowed down the problem to this error message:Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Documents". Operating system error -2147024891: "0x80070005
After re-starting the SQL Service with high enough permission to access C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\ directory, I was able to run the script and install the AdventureWorks2008 DB fine. :)
This should really be a installation requirement of the sample DB...- Proposed As Answer byJay in Bellevue Friday, November 06, 2009 7:22 AM
