Fix for Error: “FILESTREAM feature is disabled” while adding FILESTREAM

Error: FILESTREAM feature is disabled.

You will get this error while trying to add a FILESTREAM to a database without enabling it. Follow these steps to check whether FILESTREAM is enabled for your database:

  1. Open SQL Server management Studio.
  2. In the Object Explorer, right-click your server instance and select Properties.
  3. In the properties window, go to Advanced.
  4. Under Advanced, look for the status of FILESTREAM Access Level.
  5. If it’s Disabled, then you have to enable it.
Check if FILESTREAM is enabled or disabled


The solution for this error is to enable the FILESTREAM for the server instance. It has to be enabled from the SQL Server Configuration Manager. This article will give you elaborate steps to enable FILESTREAM for your SQL Server instance.

Now try adding FILESTREAM to your database. You wont get the error FILESTREAM feature is disabled anymore.


Leave your thoughts...

This site uses Akismet to reduce spam. Learn how your comment data is processed.