Autosys startup with MS-SQL fails with error SQLSTATE: IM008 Scheduler unable to connect to DB


Article ID: 130879


Updated On:


CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent


New Autosys 11.3.6 SP7 installation completes but the startup from the Services results in the following error

[04/10/2019 14:51:58] CAUAJM_E_18601 SQLSTATE: IM008, Native error: 0, Message: [Microsoft][ODBC SQL Server Driver]Dialog failed
[04/10/2019 14:51:58] CAUAJM_E_10649 Server XXXXX,1433:AEDB was not available during connection operation.


The parameter MSSQLDriverConnString in the in the configuration file (%AUTOUSER%/config.%AUTOSERV%) is missing the required value.
The value for this parameter is missing or needs to be manually set.

MSSQLDriverConnString={ODBC Driver 13 for SQL Server}



Workload Automation AE 11.3.6 SP7
Windows  2012 R2
MS SQL server 2016
Latest ODBC driver version 13  installed in addition to the native client


Upgrade the AutoSys to 11.3.6. SP7 CUM 1 or to 11.3.6 SP8 (recommended).

Additional Information

For more details please refer the documentation below