topic Re: Splunk DB Connect MS SQL DB - Connection refused in Getting Data In

Splunk DB Connect MS SQL DB - Connection refused

marellasunil — Thu, 19 Sep 2013 18:41:13 GMT

I am getting the following error while I am tring to connect Microsoft SQL database,

Encountered the following error while trying to update: In handler 'dbx-databases': Error connecting to database: java.sql.SQLException: Network error IOException: Connection refused: connect

Can anybody tell me where my setup whent wrong?

Re: Splunk DB Connect MS SQL DB - Connection refused

anwarmian — Thu, 08 Jan 2015 23:52:54 GMT

Hello Sunil,

You may have already found the solution to your query. I've encountered the same problem. Here are the two things I did to make it work. Keep in mind that it's for MS SQLServer connection only.

In db connect app: Click "Database connections in Splunk Manager" then click "New" to open the "External Databases" window. Fill in the necessary fields. Make sure "Additional JDBC Parameters" field is filled in with useCursors=true
Make sure sqlbrowser is running. sqlbrowser.exe is located in "Microsoft SQL Server" folder, for example: C:\Program Files (x86)\Microsoft SQL Server\90\Sharedsqlbrowser.exe. You can manually start the sqlbrowser by the following command: <drive>\<path>\sqlbrowser.exe -c where <drive>\<path>\ would be something like C:\Program Files (x86)\Microsoft SQL Server\90\Shared\

Check this site for database connection information: http://docs.splunk.com/Documentation/DBX/latest/DeployDBX/Addadatabaseconnection

The database.conf file stores the connection information. You can find this in dbconnect app's (dbx) local folder.

Hope this helps.

Re: Splunk DB Connect MS SQL DB - Connection refused

djarmoluk — Mon, 30 Mar 2015 23:01:12 GMT

I've tried every variation and have followed the documentation to perfection. I am not able to connect my SQL server. Keep getting java.sql.SQLException: Network error IOException: Connection refused: connect.

I'd attach a screen shot, but since I'm a loser and don't have enough Karma points, I'm not able to?!

Re: Splunk DB Connect MS SQL DB - Connection refused

rupesh_patil20 — Thu, 03 Sep 2015 10:18:00 GMT

I am also getting the same error.. can someone help us out from this. Or anyone who has did this before.. can help me to solve the issue..
I can communicate via Skype.
Awaited for your response.
Thank you

Re: Splunk DB Connect MS SQL DB - Connection refused

miteshvohra — Thu, 03 Sep 2015 10:28:11 GMT

Couple of things:
1. Grab MS SQL Server JDBC Driver 4.0 from here. Extract and drop the sqljdbc4.jar file to $SPLUNK_HOME/etc/apps/splunk_app_db_connect/bin/lib directory.
2. Restart Splunk.
3. Download the DB Connect App 2.0.4.
4. Configure MS SQL Server to use Mixed Authentication (try it before-hand via Management Console or CLI, your choice).

More Troubleshooting steps can be referred here.

If this answer has helped you, please vote and mark this as accepted answer.

Thanks, Mitesh.

Re: Splunk DB Connect MS SQL DB - Connection refused

rupesh_patil20 — Thu, 03 Sep 2015 10:47:56 GMT

Thank You Mitesh for your quick response . Give me few time. i will do it as you suggested. Will surely vote for you.

Re: Splunk DB Connect MS SQL DB - Connection refused

rupesh_patil20 — Thu, 03 Sep 2015 10:55:01 GMT

Grab MS SQL Server JDBC Driver 4.0 from here. Extract and drop the sqljdbc4.jar file in the right path.

As i did this step earlier also. just wanted to know which is the right path. If I placed it wrongly I can do correct it now.

Re: Splunk DB Connect MS SQL DB - Connection refused

rupesh_patil20 — Thu, 03 Sep 2015 11:13:27 GMT

Hi Mitesh,
Just check and let me know if it is correct http://screencast.com/t/LgULwePy

Re: Splunk DB Connect MS SQL DB - Connection refused

miteshvohra — Thu, 03 Sep 2015 15:30:45 GMT

I have updated the answer with path to the directory where the jar file needs to be copied.

Hope this helps.

Mitesh.