How to change the port number the DSM Manager uses to connect to the MDB?

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 Server Automation
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Description:

If the MDB is setup remotely and is configured to run on a non-default port all connections from the DSM Manager to the MDB will be refused by SQL Server.

In order for the SQL Server to accept connections, the DSM manager needs to be configured with the port used by the MDB.

Solution:

1. Check the Port that the Manager is configured to connect to:
   
   
   1. If the Manager is configured to connect to a non-default MDB port, the port information is stored in the comstore
      
      
   2. This can be fetched by executing the following command:
      
      
      • ccnfcmda -cmd getparametervalue -ps itrm/database/default -pn dbmsinstance
        
        
2. To update the DSM Manager to use the desired port run the following command:
   
   
• ccnfcmda -cmd setparametervalue -ps itrm/database/default -pn dbmsinstance -v "sql2005,<Port #>"
  
  Example: ccnfcmda -cmd setparametervalue -ps itrm/database/default -pn dbmsinstance -v "sql2005,1954"
  
  
3. To verify if the port information is correctly updated run the following command:
   
   
   • ccnfcmda -cmd getparametervalue -ps itrm/database/default -pn dbmsinstance

Environment

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