Post reply

Problems enabling Filestream in SQL Server 2008

  • March 5, 2010 at 11:16 am

    #212132

    Hello Everyone,

    I'm having problems enabling Filestream in SQL Server 2008. I have ensured that SQL Full-text filter daemon launcher is running. I restarted it as well. I then went to SSMS and submitted the following statements:

    sp_configure filestream, 1

    reconfigure

    I then restarted the instance and submitted the commands again.

    I didn't receive any error messages. However when I submit 'reconfigure' and look at my settings the FILESTREAM ACCESS LEVEL, only the config_value has changed and not the run_value. config_value is 1 but run_value remains 0. Moreover when I try to run the install package for Adventureworks 2008 it tells me that the filestream is enabled.

    Does anyone know what I'm missing? How can I update the run_value for FILESTREAM ACCESS LEVEL?

    Thanks in advance!

  • March 5, 2010 at 11:34 am

    #1129354

    Richard Pless (3/5/2010)

    Hello Everyone,

    I'm having problems enabling Filestream in SQL Server 2008. I have ensured that SQL Full-text filter daemon launcher is running. I restarted it as well. I then went to SSMS and submitted the following statements:

    sp_configure filestream, 1

    reconfigure

    I then restarted the instance and submitted the commands again.

    I didn't receive any error messages. However when I submit 'reconfigure' and look at my settings the FILESTREAM ACCESS LEVEL, only the config_value has changed and not the run_value. config_value is 1 but run_value remains 0. Moreover when I try to run the install package for Adventureworks 2008 it tells me that the filestream is enabled.

    Does anyone know what I'm missing? How can I update the run_value for FILESTREAM ACCESS LEVEL?

    Thanks in advance!

    It means you are in an operating system that let you install SQL Server 2008 without provisioning, what you are missing is that you need to go to Configuration Manager and enable all the options needed for FileStream. In Configuration Manager right click on SQL Server Service and go to properties then FileStream you will see all three options. The reason is in Windows 7 when the operating system does the provisioning all three options are enabled. Post again if you still need help.

    Kind regards,
    Gift Peddie

  • March 5, 2010 at 11:45 am

    #1129361

    That worked. Thanks!

  • March 5, 2010 at 11:51 am

    #1129364

    Richard Pless (3/5/2010)

    That worked. Thanks!

    I am glad I could help.

    🙂

    Kind regards,
    Gift Peddie

Viewing 4 posts - 1 through 4 (of 4 total)

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