Selecting a new or existing CMS database

Follow this procedure if you want to disconnect a CMS from its current database and connect it to an alternate database. When you complete these steps, none of the data in the current database is copied into the alternate database. If the alternate database is empty, the CCM initializes it by writing system data that is required by Crystal Enterprise. If the alternate database already contains Crystal Enterprise system data, the CMS uses that data when it starts.

Generally, there are only a few times when you need to complete these steps:

• If you have changed the password for the current CMS database, these steps allow you to disconnect from, and then reconnect to, the current database. When prompted, you can provide the CMS with the new password.
• If you want to select and initialize an empty database for Crystal Enterprise, these steps allow you to select that new data source.
• If you have restored a CMS database from backup (using your standard database administration tools and procedures) in a way that renders the original database connection invalid, you will need to reconnect the CMS to the restored database. (This might occur, for instance, if you restored the original CMS database to a newly installed database server.)

Note:    These steps are essentially the same as adding a CMS to an existing cluster; in this case, however, there are no other CMS machines already maintaining the database. For complete details about CMS clusters, see Clustering Crystal Management Servers.

To select a new or existing database for a CMS on Windows

1. Use the CCM to stop the Crystal Management Server.
2. With the CMS selected, click Specify CMS Data Source on the toolbar.

   The CMS Database Setup dialog box appears.

   

3. Click Select a Data Source; then click OK.
4. In the Select Database Driver dialog box, specify whether you want to connect to the new database through ODBC, or through one of the native drivers.
5. Click OK.
6. The remaining steps depend upon the connection type you selected:
   • If you selected ODBC, the Windows "Select Data Source" dialog box appears. Select the ODBC data source that you want to use as the CMS database; then click OK. (Click New to configure a new DSN.) When prompted, provide your database credentials and click OK.
   • If you selected a native driver, you are prompted for your database Server Name, your Login ID, and your Password. Provide this information and then click OK.

     The SvcMgr dialog box notifies you when the CMS database setup is complete.

7. Click OK.
8. Start the Crystal Management Server.

To select a new or existing database for a CMS on UNIX

Use the cmsdbsetup.sh script. For reference, see cmsdbsetup.sh.