I was trying to restore a database and got the error “System.Data.SqlClient.SqlError: FILESTREAM feature is disabled. (Microsoft.SqlServer.Smo) from the Restore Wizard.
This baffled me a bit as I know I went into the DB Server setting in Sql Manager and specifically set that value to Allow it. Well, after smacking the computer around a bit, she finally confessed that there is another place you have to enable that setting. Go figure.
You need to go to the Sql Configuration Manager (Not SQL Server Management Studio) and also enable the settings.
Here is the original error:
Here is me checking the settings on the DB:
Look, I think it’s set:
But really, no. Check the Running Values to see it laugh at you.
So, resolution? Go to Sql Configuration Manager. Open the properties window of your Server.
Check the boxes. Hit OK. Now right click your server instance and hit Restart. Watch the progress bar and ponder great thoughts.
Now, go to SQL Management Studio.
Connect to your server and run this simple command.
EXEC sp_configure filestream_access_level, 2
Now restart your Sql instance once more. You are done. Repeat whatever miserable operation you were doing before you got this error and repeat to yourself. “When I design software, I will never make someone set an option in two programs ever….ever….never ever…”