Using Windows Authentication for SQL Agent

Document ID : KB000088746
Last Modified Date : 26/10/2018
Show Technical Document Details
Issue:
When pushing the "Test" button on a SQL connection object, the SQL agent uses credentials as a local DB Account instead of an AD domain account. 
The following message appears in a pop-up window when trying to test connection using Windows Authentication rather than a SQL Login.

"This driver is not configured for integrated authentication."

 
Resolution:
The following settings and steps must be implemented to make the SQL Agent use an AD account:

-The correct sqljdbc_auth.dll must be in the bin directory (ensure the file's correct architecture, e.g. x64)
- The parameter "WindowsAuthentication" in the Agent's .ini must be set to "1" instead of "0"
- In Client 0, in UC_HOSTCHAR_DEFAULT the parameter "ANONYMOUS_JOB" needs to be set to "Y"
- Add a Connection Properties Extension in the connection object's advanced settings with parameter = integratedSecurity and value = true:

User-added image
The Agent will need to be restarted by a domain user after all the steps above have been completed. If the service manager is being used, then this can be accomplished by either starting the service manager with a domain user (not recommended) or changing the properties for the Agent on the Service Manager dialog:

User-added image