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:
Change the Registry entry for the SOURCE CONTROL-M/Server with the name of the TARGET MSSQL windows server hostname:
Change this value in the CCM
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.