Configuring Control-M/Server with MSSQL Always On

This procedure describes how to configure Control-M/Server with MSSQL Always On data replication.

NOTE: The DBUbuild and Cold restore utilities are not supported in Always On mode.

To configure Control-M/Server Always On:

1. Install or upgrade Control-M/Server on a machine using the primary node of the Always On database cluster, as described in Installing Control-M/Server on Windows.
2. Shut down Control-M/Server.
3. Send a request to the site DBA to load the standalone database into the Availability Group.

   The database is now accessed by the global listener.

4. Send a request to the site DBA to grant VIEW SERVER STATE permissions the new login.
5. Verify that the site DBA sends you the Always On listener name and port number.
6. Navigate to the following directory:

   <Control-M/Server Install Directory>\ctm_server\exe\DBUtils\DBUData\scripts

7. Run the following commands:
   • always_on_config set mode=Y
   • always_on_config set server=<listenername{,port}>

     The password for the database login remains the same.

8. Start up Control-M/Server.

   Control-M/Server is now working in Always On mode.

9. Verify Always On connectivity, by running the following command:

   <Control-M/Server_Home>\bin\DBUData\scriptsalways_on_config list pass=<Control-M/Server password>