Using AD user to connect to the event server in windows with MSSQL database

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

Originally SQL Server Credentials were used to connect to the Autosys Database, but the intent was to change it to use a Domain credential based user to connect to the Autosys Database.  But when this is attempted, during startup of Autosys below errors are seen in the logs.

CAUAJM_I_50054 Attempting (1) to Connect with Database: AUTOSYS,1433:AEDB
CAUAJM_E_18600 Database function call <SQLDriverConnect> failed in <connect SQLDriverConnect Failed> with return code: -1
CAUAJM_E_18601 SQLSTATE: IM008, Native error: 0, Message: [Microsoft][ODBC SQL Server Driver]Dialog failed
CAUAJM_E_18600 Database function call <SQLDriverConnect> failed in <connect SQLDriverConnect Failed> with return code: -1
CAUAJM_E_18601 SQLSTATE: IM008, Native error: 0, Message: [Microsoft][ODBC SQL Server Driver]Dialog failed

 

Below errors are seen on the Database Server logs:

Error: 18456, Severity: 14, State: 6.
Login failed for user 'ExampleUser'. Reason: Attempting to use an NT account name with SQL Server Authentication.

Environment

CA Workload Automation AE (AutoSys)

Resolution

As of AutoSys 12.0 SP1 (12.0.1) AutoSys has support for only the password based authentication against Microsoft SQL Server Database. Mixed mode support is not added yet for the Scheduler or Application Server or Web server.

AutoSys supports Kerberos and Wallets against Oracle database and it also supports Kerberos against Sybase database.