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 :
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