When DSM Explorer is launched why does it stop with the following error message ?
"Error connecting to database [CMM000025]"
CA Client Automation - All Versions
Make sure the following 2 things are correct:
1. You are pointing to the correct Database:
ccnfcmda -cmd getparametervalue -ps itrm/database/default -pn dbmsserver
If it is wrong, then you can use the following command to fix it:
ccnfcmda -cmd setparametervalue -ps itrm/database/default -pn dbmsserver -v <new_name>
2. You are pointing to the Correct Inst and Port:
ccnfcmda -cmd getParameterValue -ps itrm/database/default/ -pn dbmsinstance
Make sure that the SQL Port, in the above commands matches what is under SQL Configuration Manager is configured correctly.
Open the SQL Configuration Manager -> SQL Network Configuration -> Protocols for MSSQLSERVER -> Right click on TCP/IP -> Properties.
Click on the IP Address Tab and scan to bottom of the Screen
Ensure that the IPALL TCP port matches what is listed for the command above.
ccnfcmda -cmd setParameterValue -ps itrm/database/default/ -pn dbmsinstance -v <name,port>