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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

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

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...