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...

View solution in original post

0 Karma

rupesh_patil20
Path Finder

Yes I have configured it.

0 Karma

ppablo
Community Manager
Community Manager

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
.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!