Home Library Learn Downloads Support Community
Sign in | United States - English | |
13 out of 18 rated this helpful - Rate this topic

How to: Enable FILESTREAM

SQL Server 2008

Before you can start to use FILESTREAM, you must enable FILESTREAM on the instance of the SQL Server Database Engine. This topic describes how to enable FILESTREAM by using SQL Server Configuration Manager.

To enable and change FILESTREAM settings

  1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.

  2. In the list of services, right-click SQL Server Services, and then click Open.

  3. In the SQL Server Configuration Manager snap-in, locate the instance of SQL Server on which you want to enable FILESTREAM.

  4. Right-click the instance, and then click Properties.

  5. In the SQL Server Properties dialog box, click the FILESTREAM tab.

  6. Select the Enable FILESTREAM for Transact-SQL access check box.

  7. If you want to read and write FILESTREAM data from Windows, click Enable FILESTREAM for file I/O streaming access. Enter the name of the Windows share in the Windows Share Name box.

  8. If remote clients must access the FILESTREAM data that is stored on this share, select Allow remote clients to have streaming access to FILESTREAM data.

  9. Click Apply.

  10. In SQL Server Management Studio, click New Query to display the Query Editor.

  11. In Query Editor, enter the following Transact-SQL code:

    Copy 
    EXEC sp_configure filestream_access_level, 2
RECONFIGURE

  12. Click Execute.

Reference

SQL Server Properties (FILESTREAM Page)
Database Engine Configuration - Filestream

Concepts

Designing and Implementing FILESTREAM How-to Topics
Setting Server Configuration Options
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
Following steps for enable filestream gets error:

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51

The configuration option 'filestream_access_level' does not exist, or it may be an advanced option.


I am a newbie to SQL Server and am sure that there must be a step to point to Stored Proc location that I am missing. Thanks.

Nevermind, I found that in connecting I had connected to SQLEXPRESS (where filestream is not supported) - instead of SQLServer. All the above steps worked perfectly when I connected to SQLServer. Thanks.

[Tai Yee - MSFT] Thank you for following up with the resolution to your problem!

[Jie Li - MSFT] Incorrect. SQL Server Express 2008 and above support FILESTREAM. You need to enable it.
History
FILESTREAM feature is disabled
Have done steps listed above. ... several times - w/ positive confirmation.

Yet, still get the following msg when trying to create a FILESTREAM database:

"Msg 5591, Level 16, State 1, Line 1
FILESTREAM feature is disabled."

How is this possible?


----------- code sample ---------------

CREATE DATABASE FSDemo
ON
PRIMARY ( NAME = Arch1,
FILENAME = 'c:\FSDemo\archdat1.mdf'),
FILEGROUP FileStreamGroup1 CONTAINS FILESTREAM( NAME = Arch3,
FILENAME = 'c:\FSDemo\filestream1')
LOG ON ( NAME = Archlog1,
FILENAME = 'c:\FSDemo\archlog1.ldf')
GO
History
Setting FILESTREAM option twice?
One question arises which isn't explained by the article:

Why does this option have to be set twice: Once in SQL Server Configuration Manager and a second time by setting server configuration options through T-SQL in SQL Server Management Studio?
History
Filestream_Access_Levels

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

Basically:


•0 : Disables instance FILESTREAM support
•1 : Enables FILESTREAM TSQL support
•2 : Enables FILESTREAM TSQL and streaming

History