Is it ok to change the IP address of the remote MDB SQL Server?

Article Id: 127261

Status: Published

Updated On: 19-02-2019 02:25

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

Issue/Introduction:

Need to move MDB's SQL server to new hardware with a new IP address but the name will be kept so need to know if there's any issue related the IP address change.

Environment:

Release:
Component: DTSVMG

Resolution:

The remote MDB server is usually configured using the server's name so the IP address change won't have effect if DNS servers get in sync after the IP address change.

In order to be sure the Enterprise/Domain Manager is using the server name, the following command will show the configured dbmsserver name value:

ccnfcmda -cmd getparametervalue -ps itrm/database/default -pn dbmsserver