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!

Index This | I’m short for "configuration file.” What am I?

May 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with a Special ...

New Articles from Academic Learning Partners, Help Expand Lantern’s Use Case Library, ...

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

Your Guide to SPL2 at .conf24!

So, you’re headed to .conf24? You’re in for a good time. Las Vegas weather is just *chef’s kiss* beautiful in ...