locked
FILESTREAMing RRS feed

  • Question

  • Hi,
    ‌I tried to configure FileStream for testing purposes and use it in production database, but FILESTREAM area under database properties is not enabling. I've tried to use install another Express edition to test this, but it hasn't worked either. I've already enabled FILESTREAM options under SQL Server Instance properties. What else do I need to do please??

    Thanks,
    K

    Friday, March 3, 2017 1:03 PM

Answers

  • This is most frequently caused by you not running:

    exec sp_configure 'filestream access level',2
    reconfigure with override
     

    • Marked as answer by KhurramKZ Saturday, March 4, 2017 6:12 AM
    Friday, March 3, 2017 3:04 PM
  • Deleted
    • Marked as answer by KhurramKZ Saturday, March 4, 2017 6:12 AM
    Friday, March 3, 2017 3:53 PM

All replies

  • You need to enable it both in SQL Server Configuration Manager tool and also in SSMS (sp_configure).

    Tibor Karaszi, SQL Server MVP (Web Blog)

    Friday, March 3, 2017 2:10 PM
  • This is most frequently caused by you not running:

    exec sp_configure 'filestream access level',2
    reconfigure with override
     

    • Marked as answer by KhurramKZ Saturday, March 4, 2017 6:12 AM
    Friday, March 3, 2017 3:04 PM
  • Deleted
    • Marked as answer by KhurramKZ Saturday, March 4, 2017 6:12 AM
    Friday, March 3, 2017 3:53 PM
  • Thank you, worked for me :)
    Saturday, March 4, 2017 6:13 AM