All Apps and Add-ons

DB Connect - Problemas com JDBC

tsbones
New Member

Boa tarde,

Senhores, ao tentar validar minha conexão eu estou tomando o erro abaixo, estou utilizando o DB Connect 2.

Java jre1.8, o driver MS-SQL Server Using MS Generic Driver está com o status ok, funcionando.

Validating connection with URL [jdbc:sqlserver://MEU_SRV:1433;databaseName=master;selectMethod=cursor] failed: java.sql.SQLException:,Cannot create PoolableConnectionFactory (Login failed for user 'svc_splunk'. ClientConnectionId:9576d687-859f-41d6-b5f3-6be84846bf8d)
0 Karma

fer_tlaloc
New Member

That I happened to something similar had splunk enterprise in a windows server 2012 R2 with SQL server, the driver that install does not work download a driver free and now works very well, this driver is in splunk docs:

http://docs.splunk.com/Documentation/DBX/3.1.0/DeployDBX/Installdatabasedrivers

You can download it here
http://jtds.sourceforge.net/

Saludos de México

0 Karma

vasanthmss
Motivator

Hi,

Try to write a simple java JDBC connection class to validate your connection parameters. I guess the host/any connection parameter is not valid or some firewall rules?

Check the below link for prerequistites,
DB2Conenct: http://docs.splunk.com/Documentation/DBX/2.1.1/DeployDBX/Prerequisites

Below link will help you on Java code,
JAVA Class: http://www.tutorialspoint.com/jdbc/jdbc-sample-code.htm

Thanks,
V

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Is svc_splunk the correct user name? Have you verified you have the correct password for user svc_splunk?

---
If this reply helps you, an upvote would be appreciated.
0 Karma
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.