How To Enable FileStream Feature in SQL Server 2012
In this article I describe how to enable and configure using SQL Server Configuration Manager and SQL Server Management Studio
In this article I describe how to enable and configure using SQL Server Configuration Manager and SQL Server Management Studio. FileStream feature configures a BLOB data so that actual data is stored as a file on the file system instead within the database. It is the best way for storage and management of unstructured data, like documents, images, music and videos on the file system.In my previous article I explained about FileStream Feature in SQL server. You can visit from here: Working With FileStream in SQL Server 2012.
As FileStream feature is not automatically enabled, to enable and change FileStream settings follow the procedure given below. This example is developed in SQL Server 2012.
To enable FileStream settings:
Step 1
On the Start menu, select "All Programs" > "Microsoft SQL Server 2012" > "Configuration Tools". And then click SQL Server Configuration Manager.
Step 2
Following window appears when click on SQL Server Configuration Manager.
Step 3
From SQL Server Configuration Manager window, right click on SQL Server Services.
Step 4
And select Open from pop up menu.
Step 5
Right click on SQL Server (SQL Express). Select Properties.
Step 6
From SQL Server (SQLEXPRESS) Properties window, Click on FILESTREAM Tab.
Step 7
Select the Enable FILESTREAM for Transact-SQL access check box. Click Enable FILESTREAM for file I/O access checkbox to read and write FILESTREAM data from Windows and enable Allow remote clients access to FILESTREAM data checkbox also. And click Apply.
Step 8
Now open SQL Server Management Studio and connect to database engine. In the new query window type following code and execute it.
EXEC sp_configure filestream_access_level, 2
RECONFIGURE
Output: