All Apps and Add-ons

Splunk DB Connect 3 - New database connection to MS SQL Server fails?

msundaram
New Member

Splunk DB Connect 3 - New database connection to MS SQL Server fails
Connection Type: MS SQL Server using MS Generic Driver
Login failed for user 'xxx'. ClientConnectionId:ec3025ad-1c75-49de-b4d0-d5cb2d0cb372

Labels (1)
0 Karma
1 Solution

ansif
Motivator

Try the below driver:

MS-SQL Server Using jTDS Driver with Windows Authentication

And

jdbc:jtds:sqlserver://:1433/master;useCursors=true;domain=;useNTLMv2=true

View solution in original post

ansif
Motivator

Try the below driver:

MS-SQL Server Using jTDS Driver with Windows Authentication

And

jdbc:jtds:sqlserver://:1433/master;useCursors=true;domain=;useNTLMv2=true

msundaram
New Member

Cool, I am able to add the connection. THanks!

0 Karma

mmoore723
Engager

When using TLS this driver is not a option. I am trying to use the MS Generic Driver with Kerberos Authentication. I am receiving the following error message: com.microsoft.sqlserver.jdbc.SQLServerException: Integrated authentication failed. ClientConnectionId:f7ce601f-e7b6-4341-bc86-41da2dab4655 . Can someone help with how to connect to a SQL DB that is using TLS. The DB is on Windows and the HF I am using DB Connect on is RHEL 6.

0 Karma

rajanala
Path Finder

make sure the krb5.conf is in the path that is provided in the JVM options.

If the krb5.conf file is not in the /etc directory, set the following option in JVM Options under the Settings tab: -Djava.security.krb5.conf=/path/to/krb5.conf

0 Karma
Get Updates on the Splunk Community!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...