Splunk DB Connect 2: How to resolve error "The driver class net.sourceforge.jtds.jdbc.Driver is not found" to connect to Microsoft SQL?

[robertlabrie]

Splunk 6.1.2 running on Windows 2012 R1 x64. I've been using DBConnect 1 to connect to MS SQL, works fine, decided to try DBConnect 2 on a different forwarder. Says "The driver class net.sourceforge.jtds.jdbc.Driver is not found". This is new, didn't need a thing called jtds before, but ok, I go get the driver, I rummage around a little, I try putting the JRE in bin\lib and bin\lib\ext, no joy. The docs for jtds say "Being a type 4 driver, jTDS does not need any special installation. Just drop the jar file into your application's classpath and you're done." So I figured I was "done" but I guess I'm not. Anyone know how to make this work?

Thanks,
Rob

[desax]

The jar files should be placed under splunk_app_db_connect/drivers, and you should to reload the drivers page on GUI toinstall it

[bwang_splunk · Accepted solution]

The jar files should be placed under splunk_app_db_connect/bin/lib.

[behzad_341]

I think it doesn't work because I did but still the problem and error exists

[desax]

The jar files should be placed under splunk_app_db_connect/drivers, and you should to reload the drivers page on GUI toinstall it

[masterpiece]

I have rpcserver-all.jar and sqljdbc4.jar in your said location, is something missing.

[behzad_341]

I did the same but the error message still exists: java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:jtds:sqlserver...

[neelu123]

Hi Team,
I have exactly the same issue instead of jtds , am using jdbc jar i.e. sqljdbc4.jar, I have place the jar inside splunk_app_db_connect/bin/lib path but while validating connection getting the below error.

java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:sqlserver://BDOW12VSQLADMIN:1433;databaseName=Splunktest

Can someone help me to resolve the issue, is there any thing I am missing while configuring.?

Regards,
Neelu