Using Windows Authentication for SQL Agent

Document ID : KB000088746
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Using Windows Authentication for SQL Agent
Resolution:
Detailed Description and Symptoms

"This driver is not configured for integrated authentication."
 
Message appears in a pop-up window when trying to test connection using Windows Authentication rather than a SQL Login.



 

Solution
Verify the following settings have been changed:

In Client 0, UC_HOSTCHAR_DEFAULT > ANONYMOUS_JOB=Y

WindowsAuthentication=1 in the Agent's .ini

Correct JDBC driver is in the JDBC folder in the bin directory

Correct sqljdbc_auth.dll is in the bin directory.