locked
Error 5591: filestream disabled when I try to restore a database, but reaully I have enabled filestream RRS feed

  • Question

  • I am using SQL Server 2016 express, I went to manager configuration and in properties of the server, I check the three checks in the filestream tab.

    Later, in management studio, in the properties of the server, I ensure that filestream is enabled in full access mode.

    But when I have to restore a database that use filestream, I get the error 5591, that filestream is not enabled.

    Also I executed this script:

    EXEC sp_configure filestream_access_level, 2
    RECONFIGURE

    I am using windows 10 as OS.

    Thanks.

    Friday, April 7, 2017 9:26 AM

Answers

  • Try this:

    EXEC sp_configure filestream_access_level, 2

    RECONFIGURE WITH OVERRIDE

    And try your restore again.

    • Marked as answer by ComptonAlvaro Friday, April 7, 2017 11:29 AM
    Friday, April 7, 2017 10:41 AM

All replies

  • Try this:

    EXEC sp_configure filestream_access_level, 2

    RECONFIGURE WITH OVERRIDE

    And try your restore again.

    • Marked as answer by ComptonAlvaro Friday, April 7, 2017 11:29 AM
    Friday, April 7, 2017 10:41 AM
  • Thank you, it works.
    Friday, April 7, 2017 11:29 AM