SQL Server 2008 R2 FileStream RRS feed

All replies

  • Hi WolverineV9,


    Since there is less information about the server setting about if the FileStream is enbled, please follow the steps to check if it is enabled:

    1.       Open SQL Server Configuration Manager

    2.       Click SQL Server Services in the left pane

    3.       Double-click SQL Server (<instance name>) in the right pane

    4.       Switch to FILESTREAM table, check if “Enable FILESTREAM for Transact-SQL access” is enabled

    5.       Restart the service for SQL Server

    6.       Connect to SQL Server via SQL Server Management Studio

    7.       Right-click “<instance>” in the Object Explorer window and choose Properties

    8.       Click Advanced in the left pane

    9.       In the right pane, check if Filestream Access Level is set to Transact-SQL access enabled or Full access enabled


    Meanwhile could you please provide us the result of “SELECT @@VERSION”? it will be better if you could provide us the version of your operating system? Please also provide us if it is 64bit or 32bit.


    If anything is unclear, please let me know.

    Tom Li
    • Proposed as answer by Dan Randolph Wednesday, June 12, 2013 9:26 PM
    Monday, October 4, 2010 11:04 AM