Enabling Filestream in SQL Server 2012

This article describes how to enable FILESTREAM using SQL Server Configuration Manager. The Filestream enables SQL Server-based applications to store unstructured data, such as documents and images, on the file system. The FileTable feature in SQL Server 2012 builds on Filestream and you must enable this feature for FileTable to work. The example is developed in SQL Server 2012 using the SQL Server Configuration Manager. The simple procedure to do that is described here.

Simple procedure to enable and change FILESTREAM settings

1. "Start menu" -> "All Programs" -> "Microsoft SQL Server 2012" -> "Configuration Tools".

Filestream1.jpg

2. Now click "SQL Server Configuration Manager".

The following window will be opened:

Filestream2.jpg

3. "SQL Server Services" -> right-click and select "Open".

Filestream3.jpg

4. Now click on "Open".

Filestream4.jpg

5. Select "SQL Server (SQLExpress)" -> right-click then click on the property.

Filestream5.jpg

6. Now click Property.

The following window will be opened:

Filestream6.jpg

7. Now click the "FILESTREAM" tab.

Filestream7.jpg

8.  Now select all the check boxes to enable filestream for transact-SQL access.

Filestream8.jpg

9. Now click on the "Apply" button.

In SQL Server Management Studio

10. Click "New Query" to display the Query Editor or CTRL+ N and enter the following Transact-SQL code:

EXEC sp_configure filestream_access_level, 2

RECONFIGURE

11. Press F5 to execute