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
  • 5908

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.

SQL Server configuration manager.jpg

Step 2

Following window appears when click on SQL Server Configuration Manager.

SQL Server configuration manager window.jpg

Step 3

From SQL Server Configuration Manager window, right click on SQL Server Services.


sql server services.jpg

Step 4

And select Open from pop up menu.

open sql services.jpg

Step 5

Right click on SQL Server (SQL Express). Select Properties.

sql express.jpg

Step 6

From SQL Server (SQLEXPRESS) Properties window, Click on FILESTREAM Tab.

FILESTREAM Tab.jpg

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.

enable options in  FILESTREAM Tab.jpg

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:

reconfigure filestream.jpg

Categories

More Articles

© 2013 dotNetheaven. All rights reserved.