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

book

Article ID: 53300

calendar_today

Updated On:

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: