How to enable FILESTREAM features after installing SQL Server 2008?

It is possible to enable FILESTREAM after the SQL Server 2008 installation. Open the SQL Server Configuration Manager and select SQL Server Services. Right-click on the SQL Server Service, SQL Server (MSSQLSERVER), and select Properties from the available drop-down menu. Once the SQL Server properties page opens, click on the FILESTREAM tab.

If FILESTREAM is not enabled, we will get the above screen. To enable the FILESTREAM, select the checkbox next to Enable FILESTREAM for Transact-SQL access. Once you select this option, the Enable FILESTREAM for file I/O streaming access will be enabled, select the checkbox next to that. Once both the options are checked, you will get the following screen.

Click on Ok to continue. Open the SQL Server Management Studio and connect to the instance, where you want to enable FILESTREAM feature. Execute the following command:

   1:  USE [master]

   2:  GO

   3:  EXEC sp_configure 'filestream_access_level', 2;

   4:  GO

   5:  RECONFIGURE;

   6:  GO 

 

This will enable the FILESTREAM feature on the SQL Server 2008 instance.

About these ads