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!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

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