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
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

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

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...