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!

New in Observability - Improvements to Custom Metrics SLOs, Log Observer Connect & ...

The latest enhancements to the Splunk observability portfolio deliver improved SLO management accuracy, better ...

Improve Data Pipelines Using Splunk Data Management

  Register Now   This Tech Talk will explore the pipeline management offerings Edge Processor and Ingest ...

3-2-1 Go! How Fast Can You Debug Microservices with Observability Cloud?

Register Join this Tech Talk to learn how unique features like Service Centric Views, Tag Spotlight, and ...