JWP does not start | The TCP/IP connection ... port ... has failed

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

CA Automic Automation Engine JWP process does not start error message in the agent's log:

20201016/141543.845 - 33     U00003545 UCUDB: Opening database ...
20201016/141558.189 - 33     U00003611 DB OPEN executed. Return Code = '1'
20201016/141558.189 - 33     U00003590 UCUDB - DB error: '08S01', 'The TCP/IP connection to the host localhost, port 143 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".', '0', 'com.microsoft.sqlserver.jdbc.SQLServerException'
20201016/141558.189 - 33     U00032031 Error when connecting to Database


The Java Work Process (JWP) is another process of the CA Automic Automation and it has its own connection string UCSRV.INI file to be able to connect to the target database as shown below:

[JDBC]
SQLDRIVERCONNECT=jdbc:sqlserver://<servername>\<database instance>:1433;databaseName=<database name>


By default, the port number used by the MSSQL Server is 1433. However, the MSSQL server can also be configured to use dynamic port as shown in the screenshot below.

<Please see attached file for image>

 

Environment

Products: CA Automic Automation Engine, MSSQL Server
Environment: Windows

Resolution

If the MSSQL server is configured to use a dynamic port, please remove the port number 1433 from the JDBC connection string as shown below.

[JDBC]
SQLDRIVERCONNECT=jdbc:sqlserver://<servername>\<database instance>;databaseName=<database name>