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
Below are different access levels
|0||Disables FILESTREAM support for this instance.|
|1||Enables FILESTREAM for Transact-SQL access.|
|2||Enables FILESTREAM for Transact-SQL and Win32 streaming access.|
To check which access level is already in use, we can use this
SELECT SERVERPROPERTY (‘FilestrectiveLevel‘)