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

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!

Introducing Value Insights (Beta): Understand the Business Impact your organization ...

Real progress on your strategic priorities starts with knowing the business outcomes your teams are delivering ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...

Unlock Instant Security Insights from Amazon S3 with Splunk Cloud — Try Federated ...

Availability: Must be on Splunk Cloud Platform version 10.1.2507.x to view the free trial banner. If you are ...