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

[crt89]

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]

• 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]

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)