HP Systems Insight Manager 7.1 User Guide

with the new database, and the username credential that HP SIM or HP Insight Control uses to
access the new database.
NOTE: This is not supported on VCEM or Matrix Operating Environment.
NOTE: The parameters —s,—a and —b and their arguments are required. The parameter —p and
its argument is optional.
This command does the following:
• Stops all installed HP SIM or HP Insight Control services.
• Redirects the CMS to use the new SQL database.
• Modifies the CMS configuration files to reflect the new SQL server name.
• Restarts all installed HP SIM or HP Insight Control services.
Dependencies
• The database to be associated with HP SIM or HP Insight Control has been copied and setup
on a different SQL server.
• HP SIM or HP Insight Control is installed and configured on a Windows operating system,
using Microsoft SQL.
Warning
Verify that all HP SIM or HP Insight Control operations are complete before running this command.
Changing the database associated with the CMS
To change the database associated with the CMS, perform the following:
Procedure 23 Changing the database associated with the CMS
1. Open a command prompt on the CMS and navigate to the install directory of HP SIM.
2. Type the following and then press Enter.
mxreconfig —m sqlredirect -s <dbserver> -b <dbname> -a
<dbuserDomain\dbuser>
Where:
• -a <dbuser>
Name of the database user with administrative privileges, must include domain name.
• -b <dbname>
Name of the new database.
• -s <dbserver>
Name of the new database server
3. Enter the database password when prompted, and then press Enter.
Reconfiguring the CMS to use a different database 97