How to start SQL agent with Windows Authentication enabled
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: SQL Agent 

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:\####\Agents\sql\bin\ucxjsqlx.jar instead of using ucxjsqlx.exe.