FILESTREAM feature is not supported on user instances RRS feed

  • Question

  • Hallo World,

    I have message when I try to run my DataBase project on SSDT. The complete message is:

    SQL72014: .Net SqlClient Data Provider: Msg 5598, Level 16, State 3, Line 1 FILESTREAM feature is not supported on user instances.

    I really do not know FILESTREAM is supported or not. Or do I miss something!

    Need help

    Jannen Siahaan

    Tangerang - Indonesia

    Thursday, August 4, 2011 12:17 PM


  • Greetings Jannen!

    By default SSDT uses a new SQL Server Code Name "Denali" technology called LocalDB (see for more details) as the debug database for a SSDT project. This technology does not support FILESTREAMs in CTP 3, hence the error message you are seeing.

    The debug database used by a SSDT project is configurable, so if you need FILESTREAM support you can specify a different database to use for the project (e.g., a database running on SQL Server Developer Edition running your dev machine). In CTP 3 you can do this with the following steps:

    1. In Solution Explorer right-click on the project -> Properties
    2. Click on the Debug tab in the Project Properties window
    3. Edit the Target Connection String to point to an alternate database that supports FILESTREAM


    Dave Langer

    Dave Langer - Principal Program Manager SQL Server Developer Tools, Codename "Juneau".
    • Proposed as answer by Dave Langer Monday, August 8, 2011 6:53 PM
    • Marked as answer by humaNiT Monday, August 8, 2011 9:42 PM
    Monday, August 8, 2011 6:53 PM