How to change the default DB connection port (1433) of Control-M Server to a MSSQL Server Database for version 7.0.00 and 8.0.00 ONLY?

To change the default DB connection port, perform the following steps:

1. In the registry location of HKEY_LOCAL_MACHINE\SOFTWARE\BMC Software\Control-M/Server\SYSPRM

 Change the SQLSRVRNAME property to be "<sql server>,<port>"

2. You should find file named p_ctmce.bat in Control-M Server\ctm_server\exe, please edit this file and put as a first line the following string 

 - In versions 700 and 800:

      Example: set CTM_SQLSRVRNAME=CTRLMSERV-ESE01:2344

This method is not supported on Control-M 9.0.00 and higher.
Support for installation using MSSQL and a non-default port other than 1433 is first supported in version 9.0.18

Additional Information

If you made this change and did not change the java wrapper as in step #2 above, CE log files will show something similar to the following:

[INFO]   ,"2011/06/08 16:08:31.560"   ,"Database server name: <CTRLMSERV>"   ,T@10   ,com.bmc.ctms.infra.ctmdb.CtmDBDataSource   ,initConnDetails   ,com.bmc.ctms.infra.ctmdb.CtmDBDataSource   ,   ,
[INFO]   ,"2011/06/08 16:08:31.560"   ,"Database server port: <1433>"   ,T@10   ,com.bmc.ctms.infra.ctmdb.CtmDBDataSource   ,initConnDetails   ,com.bmc.ctms.infra.ctmdb.CtmDBDataSource   ,   ,
[INFO]   ,"2011/06/08 16:08:31.561"   ,"Database instance: <CTRLMSERV>"   ,T@10   ,com.bmc.ctms.infra.ctmdb.CtmDBDataSource   ,initConnDetails   ,com.bmc.ctms.infra.ctmdb.CtmDBDataSource   ,   ,
[INFO]   ,"2011/06/08 16:08:31.561"   ,"Database name: <ctrlm700>"   ,T@10   ,com.bmc.ctms.infra.ctmdb.CtmDBDataSource   ,initConnDetails   ,com.bmc.ctms.infra.ctmdb.CtmDBDataSource   ,   ,
[INFO]   ,"2011/06/08 16:08:31.562"   ,"Database user: <ctmuser7>"   ,T@10   ,com.bmc.ctms.infra.ctmdb.CtmDBDataSource   ,initConnDetails   ,com.bmc.ctms.infra.ctmdb.CtmDBDataSource   ,   ,
[SEVERE]   ,"2011/06/08 16:08:32.784"   ,"Failed to load database details from the database configuration file"   ,T@10   ,com.bmc.ctms.common.CtmProcess   ,init   ,com.bmc.ctms.common.CtmProcess   ,"com.bmc.ctms.infra.CtmDataAccessException: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The TCP/IP connection to the host  has failed. java.net.ConnectException: Connection refused: connect)

 This issue is described in CAR00044364.

After installing any Control-M Server Fix Pack, please apply again steps 1 and 2.

Legacy ID:KA351503