Upgrade Guide › Upgrading Server and Endpoint Components › Before You Begin to Upgrade › Upgrade an Existing Central Database to Microsoft SQL Server 2008

Upgrade an Existing Central Database to Microsoft SQL Server 2008

If the CA ControlMinder Enterprise Management central database is configured on Microsoft SQL Server 2005 and you want to upgrade to Microsoft SQL Server 2008, you configure the Enterprise Management Server to work with the new server.

Follow these steps:

1. Stop all CA ControlMinder services on the Enterprise Management Server.
2. Stop JBoss. Do one of the following steps:
   • If JBoss is not installed as a service, interrupt the JBoss application server window (Ctrl+C).
   • If JBoss is installed as a service, stop the JBoss service from the Services panel.
3. Upgrade to Microsoft SQL Server 2008.
4. Download the Microsoft SQL Server JDBC Driver 2.0 from the Microsoft website.
5. Extract the file to a temporary directory on the Enterprise Management Server.
6. Do one of the following steps:
   • Locate the sqljdbc.jar file, if you are using JDK version 1.5.
   • Locate the sqljdbc4.jar file and rename it sqljdbc.jar, if you are using JDK version 1.6 or higher.
7. Copy the file into the following directory on the Enterprise Management Server:

   JBoss_HOME/server/default/lib
   

   Note: Overwrite the existing file in this directory.

8. Start the Microsoft SQL Server 2008 services.
9. Start JBoss.
10. Start CA ControlMinder Enterprise Management.