CAUAJM_E_18600 Database function call <SQLDriverConnect> failed in <connect SQLDriverConnect Failed> with return code: -1

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

Following error messages are seen in event_demon and as_server logs when starting Autosys.

[10/25/2021 01:57:05]     CAUAJM_E_18600 Database function call <SQLDriverConnect> failed in <connect SQLDriverConnect Failed> with return code: -1
[10/25/2021 01:57:05]     CAUAJM_E_18601 SQLSTATE: IM008, Native error: 0, Message: [Microsoft][ODBC SQL Server Driver]Dialog failed
[10/25/2021 01:57:05]     CAUAJM_E_10649 Server WindowsServerName\SQL2019,64490:AEDB was not available during connection operation.

Environment

Workload Automation AE (AutoSys)

Resolution

DB team has updated the DB ports without informing Autosys administrator.  Autosys team fixed the config files to reflect changed port and restart to fix the issue