This Driver Is Not Configured For Integrated Authentication

October 22, 2008

Scenario:

You are trying to access a SQL Server database. It has been setup for integrated authentication. You know this because when you login via a tool like DBArtisan you don’t need to enter a user name or password. Authentication is through Windows itself.

Step 1:

You figure out that you need a specific JDBC url.

For example,

sqlserver.jdbc.url=jdbc:sqlserver://SERVERNAME;databaseName=DBNAME;integratedSecurity=true;

Step 2

You try this and get an error message like “This driver is not configured for integrated authentication.”

Solution:

  • Find the DLL
  • SQL Server

Add to path sqljdbc_auth.dll among the other 1100 or so file inside the SQL Server JDBC driver distribution and put it in the directory where your put the JDBC driver sqljdbc.jar.

Then add this directory to your PATH before running your program, eclipse, etc.


Tags: misc