Post reply

FileStreaming

  • March 3, 2017 at 5:02 am

    #401719

    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??

    Regards,
    K

  • March 3, 2017 at 9:25 am

    #1931554

    gfx99ne - Friday, March 3, 2017 5:02 AM

    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??

    Regards,
    K

    There are two things to do at the instance level - enabling in Configuration Manager as well as executing:

    sp_configure 'filestream_access_level', 2
    RECONFIGURE

    Sue

  • March 3, 2017 at 10:52 pm

    #1931654

    Sue_H - Friday, March 3, 2017 9:25 AM

    gfx99ne - Friday, March 3, 2017 5:02 AM

    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??

    Regards,
    K

    There are two things to do at the instance level - enabling in Configuration Manager as well as executing:

    sp_configure 'filestream_access_level', 2
    RECONFIGURE

    Sue

    Thank you, it worked 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply