How to start SQL agent with Windows Authentication enabled

Document ID : KB000089789
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
How to start SQL agent with Windows Authentication enabled
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.