sqljdbc_auth dll in place, MS SQL job error: This driver is not configured for integrated authentication.

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

After updating the jdbc driver by putting the jar file into the agent's /bin/jdbc folder and and renaming sqljdbc_auth.dll and placing in the agent's /bin folder, database jobs running against a MS SQL Server database are still erroring out with the following:

The database driver returned the following error message:
This driver is not configured for integrated authentication.  Client ConnectionId: [Connection Id]

The SQL Driver in question is version 12.6

Environment

Agent: Database Agent
Database Type (for the job): MS SQL Server (2016)
jdbc version: 12.6

Resolution

The sqljdbc_auth.dll file should not be renamed.  For some reason SQL Server requires it to stay as it's original name, which in this case mssql-jdbc_auth-12.6.1.x64.dll