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