Wednesday, June 17, 2009 10:44 AMHi
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
Saturday, July 25, 2009 4:44 PMHi,
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.
- Proposed As Answer by Viruk Saturday, July 25, 2009 4:51 PM