BCM and SQL2005 Server

  • Thread starter Thread starter guzzi
  • Start date Start date
G

guzzi

hi all,
i upgraded my MSDE to SQL 2000 Server, and now i'd like to update it to
SQL 2005 Server
Will BCM support it?
 
Maybe.

You should be able to create the bcm database on SQL 2005, or upgrade
an existing database's instance to SQL 2005.

However, if you have shared users, then some things (or everything!)
may not work for them because the security's been changed/tightened.
Also, the SQL 2005 service no longer runs as admin, by default, so you
may run into permission problems; e.g. backing up to a folder that sql
doesn't have permissions in.

So, upgrading to SQL 2005 sounds like an interesting project, and let
us know what you discover, but don't do it on your production bcm
database!
 
Back
Top