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:
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: