Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

[ 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

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,

https://www.devdummy.com/2019/10/dell-boomi-connecting-to-ms-sql-server.html

...


This post first appeared on Devdummy, please read the originial post: here

Share the post

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

×

Subscribe to Devdummy

Get updates delivered right to your inbox!

Thank you for your subscription

×