Yesterday I have installed SQL Server 2008. I have downloaded the product samples from codeplex and I have tried to restore the Adventure Works 2008 Sample Database but I’ve this error :
System.Data.SqlClient.SqlError: FILESTREAM feature is disabled. (Microsoft.SqlServer.Smo)
OK the FILESTREAM is disabled but the question is how can I enable it ? The solution is very simple but it took me some time to find in on google. Here’s the link to the SQL Server 2008 Books Online on MSDN – How to: Enable FILESTREAM
Just fire SQL Server 2008 Management Studio and type
EXEC sp_configure filestream_access_level, 2 RECONFIGUREI don’t know why Microsoft doesn’t provided this link as help. Instead of this they suggested m
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: FILESTREAM feature is disabled. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&LinkId=20476
which is useless.
The final result is that I have FILESTREAM enabled and I have my AdventureWorks 2008 database restored.
Now I can continue with my tests.
