[ Resolved ] SQL Error : This driver is not configured for integrated authentication - DevDummy

Latest

Views | Thoughts | Concepts | Techniques

Wednesday, October 09, 2019

[ Resolved ] SQL Error : This driver is not configured for integrated authentication



Cause of the error

When you are trying to connect to a MS SQL server database, you can enable windows authentication by setting the option integratedSecurity=true.

Error Message

Unable to connect to database; Caused by: Unable to open database connection. This driver is not configured for integrated authentication. ClientConnectionId:881352d4-91cc-49d7-a48e-a023850dbb45; Caused by: This driver is not configured for integrated authentication. ClientConnectionId:881352d4-91cc-49d7-a48e-a023850dbb45; Caused by: no sqljdbc_auth in java.library.path

Reason

However, when you set this, it will throw an error if you have not properly configured the authentication support to the driver via windows OS.

Solution

Download Microsoft JDBC Driver for SQL Server and extract the content. 
There you will find a sqljdbc_auth.dll from Microsoft JDBC Driver x.x for SQL Server\sqljdbc_x.x\enu\auth\x64
Copy that file to the System32 folder of Windows.

Now test the connection,

......

Related Articles,


...

2 comments:

  1. It just worked... Thanks...

    ReplyDelete
  2. It worked! I just had to rename the file to match the filename in the error. The error said it was looking for version 8, but I had version 9. So I just renamed the file to what they were looking for. Thanks!

    ReplyDelete