Previous Topic: Change the SA Store Connection Password in all CA Catalyst FilesNext Topic: Change CA EEM Connection Information

Customization and Maintenance › Password Maintenance › How to Change the SA Store Connection Password › Change the SA Store Connection Password in all CA SOI Files

Change the SA Store Connection Password in all CA SOI Files

Change the SA Store connection password in all CA SOI files using the EncryptSAMCreds.bat utility.

Follow these steps:

  1. Shut down the CA SAM Application Server and CA SAM User Interface Server services on the SA Manager system.
  2. Open a command prompt, navigate to SOI_HOME\Tools, and run the following command: 
    EncryptSAMCreds <old password> <new password> Database

    This command updates the database password in all necessary configuration files on the SA Manager system.

  3. Copy the SOI_HOME\tomcat\lib\hibernate.cfg.xml file on the SA Manager to <tomcat_path>\webapps\SpectrumSA on the report server, remove the <!DOCTYPE...> element at the top of the file, and save and close the file.

    Note: tomcat_path refers to the default BusinessObjects Tomcat installation directory of C:\Program Files\CA\SC\CommonReporting3\Tomcat55.

  4. Select Start, Programs, BusinessObjects XI 3.x, BusinessObjects Enterprise, Central Configuration Manager.
  5. Select Apache Tomcat and Server Intelligence Agent, click Stop, and then click Start when the services stop.

    The database password is changed on the report server.

  6. Access the Control Panel on the report server and double-click Administrative Tools, then Data Sources (ODBC).
  7. Click the System DSN tab, select SAMStore, and click Configure.
  8. Click Next, enter the new password in the Password field, and click Next again.

    The connection is verified with the new password.

  9. Click Finish.
  10. Open the SOI_HOME\Reports\samreports.xml file on the report server, enter the new password in the <password> attribute, and save and close the file.

    Future report redeployments will use the new database connection password.

  11. Start the CA SAM Application Server and CA SAM User Interface Server services.

    The password change takes effect.