How to Enable FILESTREAM on the SQL Server Instance

To enable FILESTREAM on the SQL Server instance, in SQL Server Configuration Manager right click the SQL Server Service and select properties:


On the FILESTREAM tab choose the options you want to enable:
- "Enable FILESTREAM for Transact-SQL access" - to turn FILESTREAM on
- "Enable FILESTREAM for file I/O streaming access" - to be able to read and write FILESTREAM data from Windows (enter the Windows shared folder name in the "Windows share name" box)
- "Allow remote clients to have streaming access to FILESTREAM data" -to enable access to the FILESTREAM data to remote clients.


Click 'OK' to confirm changes.

Then choose the FILESTREAM access level for the instance of SQL Server:
0 to disable FILESTREAM support for the instance
1 to enable FILESTREAM for Transact-SQL Access
2 to enable FILESTREAM for Transact-SQL and Win32 streaming access

For example, to set FILESTREAM access level to 2, run the following code fro SQL Server Management Studio (SSMS) Query Editor:

EXEC sp_configure filestream_access_level, 2

Restart the SQL Server service to enable the changes.

After FILESTREAM is enabled on the SQL Server instance, you will be able to Create a FILESTREAM Enabled SQL Server Database or Enable FILESTREAM on an Existing SQL Server Database.

If the post helped you, please share it:
Pin It

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">