How To Enable FILESTREAM Feature On SQL Server 2008

FILESTREAM is a new feature of SQL Server 2008 that supports BLOB file storage on NTFS file shares managed by SQL Server.  The FILESTREAM feature is disabled during the default SQL Server 2008 installation.

To enable FILESTREAM feature on SQL Server 2008:

  1. Open SQL Server Configuration Manager (Start > Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager)
  2. Navigate to the SQL Server Services node and select the SQL Server instance you want to modify SQL Server (MSSQLSERVER)
  3. Click the FILESTREAM tab and select the checkboxes to enable FILESTREAM and enter a share name for the files, as shown

Enabling FILESTREAM feature

  del.icio.us it!

digg it!

reddit!

technorati!

yahoo!

Advertisements

11 responses to “How To Enable FILESTREAM Feature On SQL Server 2008

  1. Thanks, It worked

  2. Worked Great! Really appreciate help such as this!

  3. Thanks so much. I’ve been rummaging the net for this.

  4. It does not work on Developer version though. Any idea? thx.

  5. I’m running developer edition and it worked fine for me Steve. What error are you getting?

  6. I don’t see SQL server configfuration manage
    I see installation center.

  7. thanks a loooooooooooot

  8. It is great ! thanks a lot

  9. I like your website and explanation seems very clear. my question now… I installed sql server 2008 community edition, tried to install adventure works database…got filestream error. now when I tried to resolve as you suggested, I am not seeing FILESTREAM tab. there are 3 tabs only, logon, service and advanced. what am I missing? is it possible to help?

    • You need to enable the FILESTREAM feature in SQL Server 2008 during the installation process. The option to enable FILESTREAM is available in the Database Engine Configuration screen of the SQL Server 2008 setup.

      If you skipped the installation during setup, you can enable FileSteam using SQL Server Configuration Manager (Start Menu > Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager). In SSCM, right-click on your SQL 2008 service, and select properties. On the FILESTREAM tab, check “Enable FILESTREAM for Transact-SQL Access”, and then “Enable FILESTREAM for file I/O streaming access”.

      You can also enable FileStream by running a SQL script:

      Use Master
      Go
      — 0 = FILESTREAM disabled
      — 1 = FILESTREAM for TSQL enabled
      — 2 = FILESTREAM for TSQL and WIN32 streaming enabled
      EXEC sp_configure ‘filestream access level’, 2
      Go
      RECONFIGURE
      Go

      For more details, see article Configure FileStream in SQL Server 2008

      • Thanks Stuart. I ran the script, gave me error, then I tried through SSCM, did not see the tab.
        in SQL script I get following error.
        Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
        The configuration option ‘filestream access level’ does not exist, or it may be an advanced option.
        did I type something wrong in server type, server name or authentication …incorrectly on logon screen or something else I missed?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s