Post reply

enable filestream

  • December 4, 2011 at 3:13 pm

    #247204

    i want to create a data base that works with filestream so i enabled it thru server configuration tool but then when i try to create to database it shows an erorr message that filestream is disabled

    this is the message

    Msg 5591, Level 16, State 1, Line 1

    FILESTREAM feature is disabled.

  • December 5, 2011 at 12:33 am

    #1416485

    How to: Enable FILESTREAM

    http://msdn.microsoft.com/en-us/library/cc645923(v=SQL.100).aspx

  • December 5, 2011 at 6:43 am

    #1416652

    It needs to be turned on at the instance level to

    It can be done through the GUI or you can use sp_configure

    EXEC sys.sp_configure N'filestream access level', N'2'

    GO

    RECONFIGURE WITH OVERRIDE

    GO

    Gethyn Elliswww.gethynellis.com

  • December 5, 2011 at 2:17 pm

    #1417036

    thanks i tried it and it was successfull

  • December 5, 2011 at 2:25 pm

    #1417040

    Good, pleased its working for you.

    Gethyn Elliswww.gethynellis.com

  • December 5, 2011 at 2:36 pm

    #1417045

    sorry now i continue to have problems first i was'nt able to create the database with file stream and with your help it worked but now i try to create the table and it fails

    this is the message

    Msg 1969, Level 16, State 1, Line 1

    Default FILESTREAM filegroup is not available in database 'AP'.

  • December 5, 2011 at 4:01 pm

    #1417064

    Do you have a filestream file group configured in your database?

    Gethyn Elliswww.gethynellis.com

  • December 5, 2011 at 4:14 pm

    #1417067

    yes

  • December 5, 2011 at 4:40 pm

    #1417071

    Here is step-by-step procedure of how to enable FILESTREAM and how to use it from SQL and in C#.

    How to use FILESTREAM

  • December 6, 2011 at 12:26 am

    #1417125

    jcgldr (12/5/2011)

    sorry now i continue to have problems first i was'nt able to create the database with file stream and with your help it worked but now i try to create the table and it fails

    this is the message

    Msg 1969, Level 16, State 1, Line 1

    Default FILESTREAM filegroup is not available in database 'AP'.

    Could you please post the DDL you are using to create the table ? Does the table have a column with ROWGUIDCOL attribute ?

    To understand how to configure the filegroups for Filestream click here.

    To check if the filegroup for Filestream has created successfully execute below query:

    SELECT * FROM sys.database_files WHERE type_desc = 'FILESTREAM'

    Sujeet Singh

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy