Splunk Search

What is the version of SQL JDBC Driver required for Splunk DB Connect 1.2 version app...?

SanthoshSreshta
Contributor

Hi.

I am trying to connect to a MSSQL server using the Splunk DB Connect 1.2 version of the app. It is showing incompatible Drivers.
Can anyone provide me the link for MS-SQL JDBC driver?
I have successfully connected to sql server using DB connect 1.1 version app. There I have used SQL jdbc 4.1, but I need it for the 1.2 version of app.
Links for reference happily accepted and appreciated.

Thanks
Santhosh

0 Karma

treinke
Builder

The documentation for the installation of the JDBC drivers is at: http://docs.splunk.com/Documentation/DBX/2.0.4/DeployDBX/Installdatabasedrivers

For Microsoft SQL, the Microsoft JDBC Drivers 4.1 and 4.0 for SQL Server is what you will want.
http://www.microsoft.com/download/details.aspx?id=11774

The steps to install them are here:
http://docs.splunk.com/Documentation/DBX/2.0.4/DeployDBX/Installdatabasedrivers#Microsoft_SQL_Server

There are no answer without questions

SanthoshSreshta
Contributor

ThanQ so much for providing links @Anthony Reinke
I am not able to connect to Sql server in 1.2 version, I have used SQL JDBC 4 drive as per the documentation found
but can able to connect through Splunk DB connect 1.1 version. Can you please help me in this.?

ThanQ,
Santhosh.

0 Karma

treinke
Builder

What error are you getting?

There are no answer without questions
0 Karma

SanthoshSreshta
Contributor

I am getting java.sql.SQLException: Network error IOException: Connection reset and object object error. 😞

0 Karma

j0shrice
Path Finder

did you get this error solved?

0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In December, the Splunk Threat Research Team had 1 release of new security content via the Enterprise Security ...

Why am I not seeing the finding in Splunk Enterprise Security Analyst Queue?

(This is the first of a series of 2 blogs). Splunk Enterprise Security is a fantastic tool that offers robust ...

Index This | What are the 12 Days of Splunk-mas?

December 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...