BCM and SQL2005 Server

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?
 
L

Luther

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!
 
Top