Getting Data In

Getting Error while doing MS Sql connection : Encountered the following error while trying to save: In handler 'databases': Error connecting to database: java.sql.SQLException: Network error IOException: Connection refused: connect

rupesh_patil20
Path Finder

I'm currently getting this error while doing trying to create an MS SQL connection:

Encountered the following error while trying to save: In handler 'databases': Error connecting to database: java.sql.SQLException: Network error IOException: Connection refused: connect

I tried the solution given on this Answers post:
http://answers.splunk.com/answers/103112/splunk-db-connect-ms-sql-db-connection-refused.html
but I'm still getting the same error. Please help.

Thank you buddy

Tags (2)
0 Karma
1 Solution

PGrantham
Path Finder

On your SQL server are you sure you have it set up to allow remote connections? Try following:
http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server...

View solution in original post

0 Karma

PGrantham
Path Finder

On your SQL server are you sure you have it set up to allow remote connections? Try following:
http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server...

0 Karma

rupesh_patil20
Path Finder

Yes I have configured it.

0 Karma

ppablo
Retired

Hi @rupesh_patil20

What version of Splunk DB Connect are you referring to?
Splunk DB Connect 1?
https://splunkbase.splunk.com/app/958/
or Splunk DB Connect 2?
https://splunkbase.splunk.com/app/2686/

It's good to always provide as much detail as possible with your issue. That link you shared is from 2 years ago and only applies to DB Connect 1, so just trying to gather information for people to best help you out.

0 Karma

rupesh_patil20
Path Finder

Okay... thanks buddy, Now I am using splunk DB connect v2, recently I have post one question regarding configuration of it plzz help me out. I have given all the information that will needed to understand the problem.

0 Karma
Get Updates on the Splunk Community!

Splunk at Cisco Live 2025: Learning, Innovation, and a Little Bit of Mr. Brightside

Pack your bags (and maybe your dancing shoes)—Cisco Live is heading to San Diego, June 8–12, 2025, and Splunk ...

Splunk App Dev Community Updates – What’s New and What’s Next

Welcome to your go-to roundup of everything happening in the Splunk App Dev Community! Whether you're building ...

The Latest Cisco Integrations With Splunk Platform!

Join us for an exciting tech talk where we’ll explore the latest integrations in Cisco + Splunk! We’ve ...