Changing the SAP Control Center Database Password

As a best practice, SAP recommends changing the SAP Control Center database password to ensure security.

1. From the command line, run C:\SMP_HOME\Servers\SQLAnywhere16\BIN32\dbisql.exe.
2. Log in to dbisql using:
   • User ID: DBA
   • Password: SAP2010_SCC
   • Host: localhost
   • Port: 3638
   • Database name: scc_repository
3. Execute the following SQL command:
   grant to connect to the database identified by NewPwd

   where NewPwd is the new password for the SAP Control Center database.

4. Shutdown the SAP Control Center service using the Windows Services tool.
5. At the command line, run C:\SMP_HOME\SCC-3_2\bin\passencrypt.bat to encrypt the NewPwd string. The output of that command is an encrypted string that is used in the next step to update the SAP Control Center configuration.
6. Modify the service-config.xml files listed below to update the corresponding password property to the new encrypted password string generated in the previous step.
   • com.sybase.asa.server.password in:

     C:\SMP_HOME\SCC-3_2\services\SccSADataserver\service-config.xml

   • com.sybase.ua.services.repository.Password in:

     C:\SMP_HOME\SCC-3_2\services\Repository\service-config.xml

   • messaging.db.password in:

     C:\SMP_HOME\SCC-3_2\services\Messaging\service-config.xml

   • alert.database.password in:

      C:\SMP_HOME\SCC-3_2\services\Alert\service-config.xml    

   Note: SAP recommends that you backup each service-config.xml before making changes. If you experience difficulty starting SAP Control Center, revert to the backed up files, set the database password back to SAP2010_SCC using step 3, then restart SAP Control Center. Contact SAP Global Support for further assistance.
7. Restart SAP Control Center.
8. Repeat steps for all affected nodes.