Problem running installation script for AdventureWorks 2008 OLTP

Question

Hi
I am unable to get the installation script ("instawdb.sql") for AdventureWorks2008 OLTP to run. The problem seems to be related to the script being unable to create a folder called "Documents" in the database installation destination folder.

I have full admin rights on the computer, so folder creation rights to this folder should not be a problem.

I have enabled Full-Text Search and Filestream (as far as I know...).

I get the following error message:

*** Creating Database

Msg 5120, Level 16, State 106, Line 2

Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\Documents". Operating system error -2147024891: "0x80070005(failed to retrieve text for this error. Reason: 1815)".

** An error was encountered during execution of batch. Exiting.

Any help much appreciated

Answer 1

Hi,

This 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.

I found this article which eventually lead me to this 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.