search cancel

How to start SQL agent with Windows Authentication enabled

book

Article ID: 89789

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

How to start SQL agent with Windows Authentication enabled

Environment

Release: AOATAM99000-8.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

Detailed Description and Symptoms

On starting, the SQL agent notes in the log that Windows authentication is enabled. But when trying to connect to the database when editing a SQL job, the following error occurs:

 

U2012031 The database driver returned the following error message:
    This driver is not configured for integrated authentication.
U2004025 Job-script execution was aborted.

 


Investigation
Checked the driver which wasn't the problem

Solution
Edit the agent in the Service Manager to run java -jar C:\UC4\Agents\sql\bin\ucxjsqlx.jar instead of using ucxjsqlx.exe.