[ 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,

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

...