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

book

Article ID: 130879

calendar_today

Updated On:

Products

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

Issue/Introduction

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.

Cause

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}
 

 

Environment

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

Resolution

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

https://docops.ca.com/ca-workload-automation-ae/11-4-2/en/administrating/ae-administration/configure-an-instance/windows-mssqldriverconnstring