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.

image

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.

image

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.

Advertisements

About Sudeepta Ganguly

A SQL Server User... Still Learning
This entry was posted in SQL Server Configuration. Bookmark the permalink.

One Response to How to enable FILESTREAM features after installing SQL Server 2008?

  1. Gabriella says:

    Thank you, brother, I searched for a solution for a long time.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s