How to enable filestream

Filestream is a feature of SQL Server 2008 to save blob data in SQL Server.

There are difference ways to enable filestream feature in SQL Server.

Using SQL Server configuration manager

Filestream can be enabled from SQL Server configuration manager. SQL Server configuration manager is located in Microsoft SQL Server 2008 folder in All Program folder

Start > Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager)

When the SQL Server configuration manager is opened, select SQL Server services, all the services of SQL Server will be opened in the Right Panel. Right click on SQL Server and select properties from the menu.

On selecting the properties from the menu, a dialog box will appear. Enable the Filestream as specified in image

Setting filestream access level from SQL Server Management Studio

Right click on SQL SERVER 2008 server node and select properties from the popup menu.

Change the filestream access level

Setting filestream access level using TSQL

EXEC sp_configure filestream_access_level, 2

RECONFIGURE

GO

Below are different access levels

 http://msdn.microsoft.com/en-us/library/cc645956.aspx

To check which access level is already in use, we can use this

SELECT  SERVERPROPERTY (‘FilestrectiveLevel‘)