Splunk Search

how to connect with db


how to connect ms-sql db with splunk.?
can anyone help me in detail.
i tried but not get success. what is the host name i should give while configuring?
please help me in step by step process.


Tags (1)

Path Finder

I imagine you are using the dbConnect app. There is a step by step in the documentation here.

A couple of notes regarding SQL Server. First, in the hostname field, you want to use an FQDN, a short name, or an IP Address. Don't use /.

In the database field, if you are using a named instance, the database field should be <instance>/<database>, otherwise, you'll want to verify the port that the instance is running on. I can't link to an external site, but if you google for "How to configure SQL Server to listen on a specific port", you'll get a link to knowledge base entry 823938‎ at microsoft, which has instructions for verifying the port that a given instance is running on.

.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!