All Apps and Add-ons

Splunk DB Connect 2: Why am I getting MS SQL Connection error "Cannot create PoolableConnectionFactory (isValid() return false)"

crt89
Communicator

Good day Splunkers,

Been stuck on this for a day. Can't get to the connectivity to work. Please see attached image for my error. (karma to low for the image)

Here's the error message when validating the connection with the db.

Validating the connection with URL
[jdbc:sqlserver://<IP here>:<port>;databaseName=faultline;selectMethod=cursor] failed: java.sql.SQLException:,Cannot create PoolableConnectionFactory (isValid() return false)

Here's my setup
- I got my Heavy Forwarder to connect to the remote MS SQL db.
- Installed Splunk DB Connect 2 app on my HF.
- Got the ports open 1433 on my HF.
- JDBC driver properly installed which is 4.0 that has support for MS SQL 2005.
- Created authentication with proper credentials.

I can't seem to figure out what I missed. What I am curious about is, do I need to also open port 1433 on the remote DB server?

Hope to hear form the community.

Thanks

fdi01
Motivator
  • DB Connect 2.0.x also requires Java 8 and Microsoft JDBC driver.
  • don't use .jar file of windows on Linux, ...
    Download the MySQL Connector/J driver, version 5.1.24 or later (mysql-connector-java-*-bin.jar).
    don't use JDBC driver version 4.0 instead version 5.1.24 or later on db2.

  • Copy the mysql-connector-java-version-bin.jar file to the
    $SPLUNK_HOME/etc/apps/splunk_app_db_connect/bin/lib directory.

DBX V2 Troubleshooting

rajbir1
Explorer

I am experiencing the exact same issue with the same setup. Below is the error:

03/03/2016 14:52:55 [ERROR] [rh_connections.py] exception java.sql.SQLException: Validating connection with URL [jdbc:sqlserver://hostname:1433;databaseName=dbName;selectMethod=cursor;integratedSecurity=true;encrypt=true;trustServerCertificate=true] failed: java.sql.SQLException:java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:e7380d53-c6cc-4b6e-bb53-ca38a6c7117d) 

2016-03-03 15:08:35 ERROR ServiceResponder:437 - Service Responder Responds Error: 
java.sql.SQLException: Validating connection with URL [jdbc:sqlserver://hostname1433;databaseName=dbName;selectMethod=cursor;integratedSecurity=true] failed: java.sql.SQLException:java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:c689377f-9412-4a53-8451-296e50bdd288)
    at com.splunk.dbx2.Connector.isValid(Connector.java:359)
    at com.splunk.dbx2.DefaultDBX2JDBC.getConnectionStatus(DefaultDBX2JDBC.java:130)
    at com.splunk.dbx2.DBX2Proxy.getConnectionStatus(DBX2Proxy.java:64)
    at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:497)
    at com.splunk.dbx2.ServiceResponder.respond(ServiceResponder.java:422)
    at org.apache.avro.ipc.Responder.respond(Responder.java:151)
    at org.apache.avro.ipc.Responder.respond(Responder.java:99)
    at org.apache.avro.ipc.ResponderServlet.doPost(ResponderServlet.java:48)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
    at org.eclipse.jetty.server.Server.handle(Server.java:497)
    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
    at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
    at java.lang.Thread.run(Thread.java:745)
0 Karma
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!