SqlError: FILESTREAM feature is disabled

I recently ran into this filestream SQL error when trying to restore a backup database. I have restored many databases in the past with no problem so I was a bit confused by the error. After googling it I found this post and it helped to fix the error!

http://brianseekford.com/index.php/2011/05/17/how-to-fix-sqlerror-filestream-feature-is-disabled/

Essentially you need to follow the steps below:

1. Open SQL Configuration Manager and locate your database then right click on it and open up the properties
2. Navigate to the FILESTREAM tab and check all the checkboxes then click apply
3. Right click on your database again and restart it
4. Close SQL Server Management Studio if it was opened then open it up again
5. Run the query below
1. EXEC sp_configure filestream_access_level, 2
2. RECONFIGURE
6. Close SQL Server Management Studio and reopen it
7. Now you should be able to restore the database!