It is currently 21 Oct 2017 1:38


Post new topic  Reply to topic  [ 2 posts ] 
Author Message
PostPosted: 29 Mar 2013 4:32 
Offline
Nouveau
Nouveau
User avatar

Joined: 10 Dec 2007 12:00
Posts: 69
Location: Boston
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?


Top
   
 Post subject:
PostPosted: 04 Apr 2013 4:11 
Offline
Nouveau
Nouveau
User avatar

Joined: 14 Jan 2010 12:00
Posts: 58
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.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 2 posts ] 

All times are UTC+02:00


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved