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

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

We are using a SQL id to connect to the database but we want to change it to use domain id to connect to the database.

I added an domain id in SQL and gave it ujoadmin role. In default schema, I wrote 'dbo'. But, we are seeing errors in the logs.

CAUAJM_I_50054 Attempting (1) to Connect with Database: wvappi02085.testbns.bns,5150:AEDBTID
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

Error from the DB logs:

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

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

As of AutoSys 12.0 sp1 AutoSys has 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.