When DSM Explorer is launched it stops with the following error message : "Error connecting to database [CMM000025]"

Products

• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager
• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Question:

When DSM Explorer is launched why does it stop with the following error message ?

             "Error connecting to database [CMM000025]"

 

Environment:                                          

CA Client Automation - All Versions

 

Answer:

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>

      

Environment

Release: UASIT.99000-12.8-Asset Intelligence
Component: