All Apps and Add-ons

DB Connect (latest as of 8/8) connecting to mircosoft sql server

New Member

I am trying to connect a sql server database to Splunk. I keep getting the error: "Error in 'dbxquery' command: Could not find file: 'java.path'." I have a Java folder in C:\Program Files\Java where I have a jre1.8.0 file and a sqljdbc_4.2 file. In Configurations/Settings/General the JRE path is C:\Program Files\Java\jre1.8.0_221 and task server port is 9998.
I have:
- installed the sql server generic driver and the jTDS driver
- put the sqljdbc_auth.dll file in my windows/system32 folder
- put jtds jar file and sqljdbc42 jar file in C:\Program Files\Splunk\etc\apps\splunk_app_db_connect\drivers.

I have a valid connection set up with the correct identity for my database. I've gone through the documentations many times and the trouble shooting techniques but I'm not sure how to fix this error. I'm also using trial mode so I'm not sure if that makes a difference

0 Karma



When you install DB connect for Splunk , you need first to install and setup the JDBC (Java Database Connectivity database) driver.
You need to configure the driver and java into the UI of DB connect on your Splunk instance. In my cases i always use the driver JTDS with windows authentication the other one doesn't work (dont know why) try different drivers maybe.

Check this:

Hope it helps


0 Karma
Get Updates on the Splunk Community!

2024 Splunk Career Impact Survey | Earn a $20 gift card for participating!

Hear ye, hear ye! The time has come again for Splunk's annual Career Impact Survey!  We need your help by ...

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.2.2403! Analysts can ...