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