Upgrade Guide › Upgrading Databases › Pre-upgrade Database Considerations › SQL Server Issues

Previous Topic: Oracle Issues

Next Topic: Database Schema Change

SQL Server Issues

Be aware of the following issues if upgrading from version 5.0:

SQL Server 2000 not supported

Important! If upgrading from version 5.0, be aware that SQL Server 2000 is no longer supported.

If your existing CMS has a SQL Server 2000 database, you must upgrade to SQL Server 2005 or 2008 before you can upgrade your CMS.

SQL Server logins require SQLAgentUserRole database role

Only required if upgrading from version 5.0.

Before you upgrade a SQL Server CMS, you must manually grant the SQLAgentUserRole database role in the msdb database to your SQL Server primary user. The primary user needs this role to create and schedule SQL Server Agent jobs. (This role is granted automatically when you install a new SQL Server CMS.)

Note: The full range of required roles is listed in the Database Guide; search the index for ‘SQL Server, logins’.