Getting error CAUAJM_E_18601 SQLSTATE: IM008, Native error: 0, Message: [Microsoft][ODBC SQL Server Driver]Dialog failed

book

Article ID: 221855

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

We get this error when we start the scheduler and application server

[07/29/2021 14:12:24] CAUAJM_E_18600 Database function call <sqldriverconnect> failed in <connect> with return code: -1

[07/29/2021 14:12:24] CAUAJM_E_18601 SQLSTATE: IM008, Native error: 0, Message: [Microsoft][ODBC SQL Server Driver]Dialog failed

[07/29/2021 14:12:24] CAUAJM_E_10649 Server xxxxx-xxxxxx01,1443:xxxxxxsql was not available during connection operation.</connect></sqldriverconnect>

Environment

Release : 11.3.6

Component :

Resolution

Verified if any new ODBC driver got installed in the autosys server

Run 'ODBC 32 bit Data sources'

Click on drivers and see if there is an ODBC driver installed other than native client.

The only driver available was  Native Client 11.0.

Added the parameter MSSQLDriverConnString={SQL Server Native Client 11.0} to the config.$AUTOSERV file.

The Autosys application has now started OK and is running OK.