All Apps and Add-ons
Highlighted

How do you resolve a Splunk DB Connect MSSQL Error?

New Member

Hi All,

I was able to create 3 MSSQL connections using Generic Driver successfully. But the 4th connection fails with "DBX Server did not respond within 310 seconds, please make sure it is started and listening on 9998 port or consult documentation for details.

HTTPConnectionPool(host='127.0.0.1', port=9998): Read timed out. (read timeout=310)"

On log, I can see "Prelogin error: host 172.xx.x.xx port 1433 Error reading prelogin response: Connection timed out (Read failed)"

I am using DB Connect v 3.1.4.

Kindly advise how to resolve this issue. Thank you

0 Karma
Highlighted

Re: How do you resolve a Splunk DB Connect MSSQL Error?

Communicator

I am not sure, if this is your solution, but with DB Connect input, you can set a timeout (the time, Splunk waits for an answer, after query is fired). It is possible, that your data base is very large, which needs some more time to get a response. At first i would just try playing around with the time out value (in seconds).

View solution in original post

0 Karma
Highlighted

Re: How do you resolve a Splunk DB Connect MSSQL Error?

New Member

This issue has been resolved by adding the application to whitelist on firewall, previously only the ports were enabled.

0 Karma
Highlighted

Re: How do you resolve a Splunk DB Connect MSSQL Error?

Engager

Which application needs to be added

0 Karma
Highlighted

Re: How do you resolve a Splunk DB Connect MSSQL Error?

New Member

This issue has been resolved by enabling the application on firewall, previously only the ports were enabled.

0 Karma