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

Document ID : KB000053300
Last Modified Date : 14/02/2018
Show Technical Document Details

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