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 9 (of 9 total)

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