HELP - Database Server Name Change
HELP - Database Server Name Change
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?
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.
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.