Friday, June 05, 2009 8:21 PM
I am using SQL Server 2008. I downloaded and installed the SQL2008.AdventureWorks_All_Databases.x86.msi file from http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=18407. However, the following 5 sample databases end up being installed:
AdventureWorks (this is the 2005 version)
AdventureWorksDW (this is the 2005 version)
AdventureWorksLT (this is the 2005 version)
What happened to the AdventureWorks2008 sample database, and why are SQL Server 2005 versions of the sample databases mixed in with this download?
Saturday, July 25, 2009 4:50 PM
Failure to install AdventureWorks2008 appears to be caused by the account under which the SQL Server Service is running (not the person running the installation package). I had used Network Service, but changed it to Local Service and the installation of AdventureWorks2008 then worked.
You can find error messages in the event log such as...
Event Type: Error
Event Source: MSSQLSERVER
Event Category: Server
Event ID: 17207
STREAMFCB::Startup: Operating system error 0x80070005(failed to retrieve text for this error. Reason: 1815) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Documents'. Diagnose and correct the operating system error, and retry the operation.
This occurs when the CREATE DATABASE statement is executed in the installation script, when it tries to create the Documents folder. This fails due to an issue with permissions (0x80070005 is a generic permission denied error code).
I found this article which eventually lead me to the resolution: http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=435855.
It mentions a bug introduced by Windows Update patch KB956572 (http://support.microsoft.com/kb/956572).
Apparently any account (with suitable local permissions) will work correctly, except Network Service or Local System.
Hope this helps with part of your question.
- Proposed As Answer by Viruk Saturday, July 25, 2009 4:51 PM
Sunday, July 26, 2009 12:05 AMViruk,
Thank you for your helpful solution. I will give it a try and let you know if it works for me.