0

I'm having problems getting filestream to work. I know how to configure it, and have setup numerous servers running it. For some reason, even though Filestream is definitely enabled, I keep getting this error when trying to restore a filestream enabled database...

FILESTREAM feature is disabled.

I may need some suggestions beyond the obvious.

enter image description here

enter image description here

If I try to add a filestream filegroup to a test database, like so...

ALTER DATABASE test_fs
  ADD FILEGROUP [FS] CONTAINS FILESTREAM 
GO

I get...

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

If someone could give me some suggestions about what to check, it would be greatly appreciated.

user1751825
  • 435

3 Answers3

1

Are you on Win10 build 15063.x? If so, there is a bug which effects filestream. Installing SQL 2016 sp1 might help.

gokhan
  • 11
0

I second the confirmation above. I'm on Windows 10 build 15063.138 and I have SQL 2016 with SP1 and I get the same error.

Thank you for at least validating what I'm seeing. There doesn't seem to be a work-around posted at this time.

More detail on the bug is posted here: https://blogs.msdn.microsoft.com/sql_server_team/filestream-issues-with-sql-server-on-windows-10-creators-update/

Joel
  • 26
0

Fist you have to enable FILESTREAM in GUI as is shown. Then create New Query In Query Editor, enter the following Transact-SQL code: EXEC sp_configure filestream_access_level, 2 RECONFIGURE

https://msdn.microsoft.com/en-us/library/cc645923(v=sql.105).aspx Now it works for me.

bob
  • 1