Dec 02, 2010 New book: Windows Communication Foundation 4 Step. Sharp’s Windows Communication Foundation 4 Step. The file AdventureWorks2008_SR4.exe.

The Documents folder is suppose to get created during the installation and is used to store FILESTREAM data for a column in the database. I believe that the error message you're getting is related to a permissions problem related to the account running the SQL Server service. If you have NT AUTHORITY NETWORK SERVICE as the account running the instance of SQL Server, it may not have sufficient privilege to create the Documents folder or write to it. Here's a couple of things to try. Run Management Studio as administrator.

(right-click SQL Server Management Studio and select Run As Administrator). Execute the instawdb. Ragequit Holidays there. sql script.

(hopefully this will give you sufficient permissions to create the Documents folder and successfully install. If it doesn't, then try the following: 1. Manually create the folder C: Program Files Microsoft SQL Server MSSQL10.MSSQLSERVER1 MSSQL DATA Documents. Give the account that is running your SQL Server service full permissions to modify that folder. Try the installation script again (or alternatively, try running the.exe from Codeplex again. In the meantime, I'm forwarding this post to someone on the Samples team to see if they have any addtional insights or suggestions.

Regards, Gail Gail Erickson [MS] This posting is provided 'AS IS' with no warranties, and confers no rights. The AdventureWorks2008 database has requirements that the other databases do not. That is, you must have full-text search installed and enabled and you must have FILESTREAM enabled. The steps for ensuring these are setup correctly are documented here:.

Once you have completed these steps, you can successfully install the sample database. If you have already the prequisites installed correctly, then please provide the exact error message that you get. Regards, Gail Gail Erickson [MS] This posting is provided 'AS IS' with no warranties, and confers no rights. When I try to execute the Adventureworks2008 DB it gives me following error. Msg 5105, Level 16, State 2, Line 2 A file activation error occurred.