topic Re: Error: This driver is not configured for integrated authentication in Splunk ITSI

Error: This driver is not configured for integrated authentication

arun_kant_sharm — Wed, 02 Dec 2020 03:59:36 GMT

Hi Experts,

I am getting error during I tried to create new ms-sql connection on my Splunk server (i.e Amazon Linux 2).

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

JDBC URL : jdbc:sqlserver://xx.xx.xxx.xx:1433;databaseName=master;selectMethod=cursor;integratedSecurity=true ERROR : This driver is not configured for integrated authentication. ClientConnectionId:d3c9028f-187a-492f-89da-68dfceadceb1 Java version on my splunk server : java version "1.8.0_201" Splunk DB Connect version: DBX:3.1.4 Splunk Server OS: Amazon Linux 2 AMI

The driver present in my machine are:

Re: Error: This driver is not configured for integrated authentication

vikkysplunk — Thu, 29 Apr 2021 02:07:41 GMT

@arun_kant_sharm is these issue resolved. I am also getting the same error

Re: Error: This driver is not configured for integrated authentication

lumpymilk — Wed, 08 May 2024 13:37:48 GMT

Here is what I found. When using that connection type we needed to add an option authenticationScheme=NTLM (which enables NTLMv2 authentication) and then in our environment we made sure SSL is enabled (encrypt=true) and added the option trustServerCertificate=true.
After that, the connection could be saved and worked fine.