Enable FILESTREAM Support in SQL Server

Professionaluser
Posted by Professionaluser under Sql Server category on | Points: 40 | Views : 139
To enable FILESTREAM support on a SQL Server instance, we need to enable the options under FILESTREAM tab of the Properties of SQL server instance on which you wanted to enable filestreaming under SQL Server Configuration Manager.

After changing/enabling FILESTREAM options, you need to restart the service, then run the below query in SSMS ( SQL editor)

USE master
Go
EXEC sp_configure 'show advanced options'
GO
EXEC sp_configure filestream_access_level, 2 -- 0 = disabled, 1 = T-SQL access enabled , 2=Full access
GO
RECONFIGURE WITH OVERRIDE
GO

Comments or Responses

Login to post response