How do we fix this error: This driver is not configured for integrated authentication?

[vikkysplunk]

Hi All,

I am getting error during I tried to create new ms-sql connection on my Splunk server.

Connection Type: MS-SQL Server Using MS Generic Driver With Windows Authentication

JDBC URL : jdbc:sqlserver://X.X.X.X:1433;databaseName=master;selectMethod=cursor;integratedSecurity=true

ERROR : This driver is not configured for integrated authentication. ClientConnectionId:8cf05a84-6449-4ca7-b714-eb95d52480f7

Java version on my splunk server : jre1.8.0_281

Splunk DB Connect version: DBX:3.5.1

Splunk Server OS: CentOS 7

Drivers in my machine :

[cdaly]

We are seeing this same error.  @vikkysplunk did you find a solution?

This driver is not configured for integrated authentication.

[cdaly]

ERROR : This driver is not configured for integrated authentication. ClientConnectionId:xxxx

I was able to resolve this issue by adding the mssql-jdbc_auth-9.2.1.x64.dll from the new jdbc driver to the Java/JRE x/Bin and Java/JRE x/Lib directories. 

Also had to Restart Splunk