SQL jobs are failing with port number 1433/msdb is not valid message

Products

• Autosys Workload Automation

Issue/Introduction

When attempting to run a SQL job, receiving the following error message in the sql.log file:

The port number 1433/msdb is not valid

Environment

All Agents configured to use the SQL Plugin

Resolution

To take care of the error that the port number 1433/msdb is not vaild, do the following:

• Verify that the SQL Plugin is installed by running cybAgent -vv.
• Confirm that jtds_1.3.1.jar exists in the <main Agent directory>\jars\ext directory.
• In the agentparm.txt file, ensure it is referencing the correct properties file located in the <main Agent directory>\sql\config directory.
• Important: After making any changes based on the above verifications, the Agent service will need to be restarted.