HELP - Database Server Name Change

Everything about Enterprise ControlStation Server installation or setup.
Post Reply
User avatar
Hubba
Nouveau
Nouveau
Posts: 69
Joined: 10 Dec 2007 12:00
Location: Boston

HELP - Database Server Name Change

Post by Hubba » 29 Mar 2013 4:32

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?

User avatar
jstarkw
Nouveau
Nouveau
Posts: 58
Joined: 14 Jan 2010 12:00

Post by jstarkw » 04 Apr 2013 4:11

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.

Post Reply