Enable FILESTREAM feature

• Mani-584606

  SSChampion

  Points: 11788

  More actions

  April 28, 2010 at 1:15 pm

  #232127

  I did NOT select the FILESTREAM feature while installing the SQL Server 2008. But now I want eanble & explore this feature. How can I enable this feature from Management studio or T-sql script?

  Thanks

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  April 28, 2010 at 1:52 pm

  #1159271

  Open SQL Configuration Manager

  Choose SQL Server Services

  Right-Click on the SQL Server and click on Properties.

  Go to the FILESTREAM tab..

  Set your options, click ok..

  Probably have to restart SQL for them to take effect.

  CEWII