Upgrading SQL 2005 to 2008 with FileStream support

Question

Post reply

Upgrading SQL 2005 to 2008 with FileStream support

bill.jordan

SSC Rookie

Points: 31
More actions
August 29, 2010 at 9:41 pm

#226333

I am trying to upgrade an existing instance of SQL 2005 Express to 2008 R2 Express. The upgrade works, but when I try to enable FileStream support on the DB it fails stating that that support is not enabled.

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

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

VastSQL SSC-Dedicated Points: 36278 More actions · Answer 1

Go to SQL Server configuration manager-->right click server service-->properties-->filestream tab-->enable

EXEC sp_configure filestream_access_level, 2

RECONFIGURE

You can also try server properties-->advaced--Filestream access level..but this seems to be not changing even after changing under configuration manager..Hope any other experts might help in understanding why thats happening..

bill.jordan SSC Rookie Points: 31 More actions · Answer 2

Thanks, but I should have been more clear. This is scripted install as part of a software setup. Also, my upgrae scripts already perform those steps (except for level 1), and those succeed. it is the following mandatory step (the ALTER DATABASE ) to actually set up the filestream on the DB that fails, stating that filestream support is not enabled. I can not use the configurationmanager for two reasons: first, I am not installing it on the target machine (DB server only), and second, the end users would have no idea what to do with it.

VastSQL SSC-Dedicated Points: 36278 More actions · Answer 3

Hi Bill,

Filestream is a server level configuration and you cant enable that using ALTER Database..

bill.jordan SSC Rookie Points: 31 More actions · Answer 4

Sometimes I wish people would actually read the entire post before commenting on one snippet. I understand that filestream is a server level configuration. That is why the original question was how to enable it during the upgrade from 2005. You initially answered by telling me to run sp_configure, etc. I was simply telling you that I have done that to try to enable filestream support on the particular DB and that that succeeded and the ALTER failed. That was how I first became aware that the filestream support was not enabled on the server.

So, I appreciate your response and would welcome ANY help, but the real problem is this:

I need to find a way to upgrade an Express version of SQL 2005 to 2008 R2 Express and enable Filestream support along the way. I cannot do this through Config Mgr as I don't install it (and don't really want to) and this is a silent install as part of a software package for end users who can't even spell "DB".