All Apps and Add-ons

How to connect Microsoft SQL server from Splunk 6.2 with JDBC drivers, JRE?

lakshmiprasad
New Member

I am new to Splunk technology and I would like to learn Splunk.
I have tried to connect a Microsoft SQL server from Splunk, but I am not able to figure out the settings. I tried locally with Splunk 6.2, JRE, and JDBC drivers, but it's showing RPC service down.

Could you please help on this.

I have attached a screenshot please refer those settings.

0 Karma

esix_splunk
Splunk Employee
Splunk Employee

Use DBConnect (DBX) to connect to Sql. https://splunkbase.splunk.com/app/2686/.

DBConnect will give you ability to perform near-full SQL queries to populate Splunk with assorted DB housed data.

lakshmiprasad
New Member

Hi,

Thanks for reply , i have already used DBConnect (DBX) to connect SQL Server but it couldn't connect.

it is saying RPC service down.

I have done the below steps for configuration (http://docs.splunk.com/Documentation/DBX/2.0.0/DeployDBX/Checklist)

1) Installed Splunk Enterprise 6.2.2 (free trail)
2) Java SE Runtime Environment (JRE) 8
3) Splunk DB Connect 2
4) JDBC driver for Microsoft SQL server

When I try configure settings it is showing RPC service down and not able to connect the database.

Could you please help on this?

0 Karma
Get Updates on the Splunk Community!

Announcing the Expansion of the Splunk Academic Alliance Program

The Splunk Community is more than just an online forum — it’s a network of passionate users, administrators, ...

Learn Splunk Insider Insights, Do More With Gen AI, & Find 20+ New Use Cases You Can ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Buttercup Games: Further Dashboarding Techniques (Part 7)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...