topic Re: Splunk DB Connect with Microsoft SQL Database: Why do I keep getting error "Connection refused"? in Splunk Search

Splunk DB Connect with Microsoft SQL Database: Why do I keep getting error "Connection refused"?

djarmoluk — Mon, 30 Mar 2015 23:05:30 GMT

I realize this question has already been posted, but none of the answers have helped me. I have followed this document line by line: http://docs.splunk.com/Documentation/DBX/1.1.7/DeployDBX/Addadatabaseconnection

No matter what I try, I keep getting:

java.sql.SQLException: Network error IOException: Connection refused: connect

I'd attach a screen shot of my settings, but I'm not able to add an attachment. So how does one with low karma get support in this community? Seems unproductive to not allow me to upload an image which may more quickly get my question answered.

Re: Splunk DB Connect with Microsoft SQL Database: Why do I keep getting error "Connection refused"?

ppablo — Mon, 30 Mar 2015 23:15:10 GMT

Hi @djarmoluk

Can you host the image on another site and share that link here on the post? That's what most folks do until they earn enough karma from participation in the forum to attach images.

Re: Splunk DB Connect with Microsoft SQL Database: Why do I keep getting error "Connection refused"?

djarmoluk — Tue, 31 Mar 2015 01:44:38 GMT

Thank you!

https://s3.amazonaws.com/jarmoluk-public/Screen+Shot+2015-03-30+at+5.58.30+PM.png

I've tried my machine name, localhost, 127.0.0.1, and the IP address shown as the host name. I've also tried all of the isolation levels available. The database name, username, and password have also been verified.

Re: Splunk DB Connect with Microsoft SQL Database: Why do I keep getting error "Connection refused"?

rsennett_splunk — Tue, 31 Mar 2015 01:53:43 GMT

and you're sure that it's using the default port of 1433? Might want to confirm that, and that you have the port open on both ends...

The image restriction is to prohibit spammer activity. It doesn't take long to hit the threshold. 🙂

Re: Splunk DB Connect with Microsoft SQL Database: Why do I keep getting error "Connection refused"?

djarmoluk — Tue, 31 Mar 2015 02:13:37 GMT

I've confirmed the port. I'm actually running splunk and the db server on my test machine - firewall is off.

Re: Splunk DB Connect with Microsoft SQL Database: Why do I keep getting error "Connection refused"?

djarmoluk — Tue, 31 Mar 2015 02:34:21 GMT

Apologies... I have to correct myself. TCP/IP for local install of SQL defaults to off... so 1433 wouldn't have been inaccessible. Enabled it and restarted... now I'm getting the following:

Encountered the following error while trying to save: Splunkd daemon is not responding: ('Error connecting to /servicesNS/admin/dbx/dbx/databases: The read operation timed out',)

Re: Splunk DB Connect with Microsoft SQL Database: Why do I keep getting error "Connection refused"?

jcoates_splunk — Sat, 11 Apr 2015 20:46:36 GMT

REST endpoints are much slower on Windows, which I assume is what you're using... a few retries might get you through it, or if that's a VM where you can increase hardware resources that might work.

Re: Splunk DB Connect with Microsoft SQL Database: Why do I keep getting error "Connection refused"?

patelrahul40 — Mon, 14 Dec 2015 08:54:09 GMT

hey, I am also getting this error while connecting to remote mysql server ,but it working fine with local mysql server,

Please find the Error details

Splunkd daemon is not responding: ("Error connecting to /servicesNS/admin/dbx/dbx/databases: ('The read operation timed out',)",)

Re: Splunk DB Connect with Microsoft SQL Database: Why do I keep getting error "Connection refused"?

jkat54 — Mon, 14 Dec 2015 11:25:32 GMT

The answer being... by default MS SQL disabled TCP/IP and 1433 on the Network Interface Card.

To enable you must open SQL Server Configuration Manager, select the protocol you want to use (TCP/IP) in this case, enable the protocol, then go to advanced and enable the protocol on the NIC/IP address(es) you desire.

Once you have done so, you will be able to connect to your SQL server.

Re: Splunk DB Connect with Microsoft SQL Database: Why do I keep getting error "Connection refused"?

jkat54 — Mon, 14 Dec 2015 11:26:43 GMT

please ask a new question and mark the answer for your original error.