Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 FILESTREAM error

Author  Topic 

sprdave
Starting Member

1 Post

Posted - 2009-08-29 : 23:13:01
I am at the end of my rope, someone please help.

I CANNOT successfully install the AdventureWorks DB's for SQL Server 2008. I have tried the releases from CodePlex, I have had friends from Microsoft just e-mail me the .BAK files. In a nutshell I keep getting this error:

System.Data.SqlClient.SqlError: FILESTREAM feature is disabled. (Microsoft.SqlServer.Smo)

FILESTREAM to the best of my knowledge is enabled. This is driving me insane.

I also tried to install this file (instawdb.sql) from each of the codeplex sample database downloads, but I do not know enough about T-SQL and where to put "my paths" in the script to make the query work.

In a nutshell. The .BAK files a friend from Microsoft sent me, and the CodePlex installer download gives the above error.

And I not smart enough to know what to type and where to put it if I try and install manually using the instawdb.sql file.

Please help this is driving me insane!!

Thanks, Dave

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-08-30 : 11:16:02
You need to enable FILESTREAM, using sp_configure or the Configuration Manager. It is not on by default.
http://msdn.microsoft.com/en-us/library/cc645923.aspx
Go to Top of Page
   

- Advertisement -