Page 1 of 1

HELP - Database Server Name Change

Posted: 29 Mar 2013 4:32
by Hubba
We are upgrading our SQL server and the server name is changing. Is there any other place to change the physical server name other than in the ConfigurationMgr Hostname and Port under Databases?

Posted: 04 Apr 2013 4:11
by jstarkw
Hi,

Also need to make a change in registry where your EM and server are inststalled.

Change the ODBC connection in the registry for SOURCE EM with the name of the TARGET MSSQL windows server hostname:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.ini\CTMEM640_default

Change the Registry entry for the SOURCE CONTROL-M/Server with the name of the TARGET MSSQL windows server hostname:

HKEY_LOCAL_MACHINE\SOFTWARE\BMC Software\CONTROL-M/Server\SYSPRM\SQLSRVRNAME*

Change this value in the CCM
Database->location

If you are moving to a brand new server do this first.

Install MSSQL in the new Server (TARGET database)

Create EM and Control-M DBO users with the same name and passwords as the SOURCE database.

Create TARGET EM and Control-M databases with a size equal to the SOURCE database.

Stop the SOURCE EM and Control-M Server applications.

Backup the SOURCE EM and Control-M databases.

Restore the SOURCE database backups on the TARGET MSSQL server.