When you are trying to restore one database and you stuck with the error showing FileSTREAM feature is disabled.
Solution
   EXEC sp_configure filestream_access_level, 2
Contents
hide
Â
Solution
To enable and change FILESTREAM settings
   In the list of services, right-click SQL Server Services, and then click Open.
   In the SQL Server Configuration Manager snap-in, locate the instance of SQL Server on which you want to enable FILESTREAM.
   Right-click the instance, and then click Properties.
   In the SQL Server Properties dialog box, click the FILESTREAM tab.
   Select the Enable FILESTREAM for Transact-SQL access check box.
   Click Apply.
   In SQL Server Management Studio, click New Query to display the Query Editor.
   In Query Editor, enter the following Transact-SQL code:
   EXEC sp_configure filestream_access_level, 2
RECONFIGURE
   Click Execute.
   Restart the SQL Server service.
I can reach at : durgacharanojha@yahoo.co.in
nice info 🙂
Please visit my blog
Just FYI, there’s an event for bloggers and the prizes are iPad2 and Cash. Find the info here. 🙂
I’m trying to enable Filestream in SQL Server 2008 and I Do not have SQL Server Management Studio component installed on my computer, all info I’ve found already needs the Management studio, how could I enable it without it? thanks