Post reply

Installing AdventureWorks2008 database: "filestream not enabled"

  • May 5, 2010 at 10:59 pm

    #224206

    Hi,

    I've downloaded the executable which installs sample databases on SQL Server 2008:

    http://msftdbprodsamples.codeplex.com/releases/view/37109

    After running it I got this message for AdventureWorks OLTP 2008 database:

    "filestream not enabled"

    I've enabled filestream:

    sp_configure [filestream access level], 1 -- tried both 1 and 2

    reconfigure with override

    go

    Still getting the same message when installing the databases.

    Any ideas?

    Thanks.

  • May 5, 2010 at 11:30 pm

    #1162954

    Found it out!

    "sp_configure [filestream access level], 1" only changes the "config" value, not run value, so sql server configuration manager should be used to finish the configuration.

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

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