I'm using Pythons Requests module to try and hit a SolarWinds DB. I have two different DB's I'm trying to connect too, and the first one is working successfully however the second is proving difficult. I keep getting a 10054 error ( 'An existing connection was forcibly closed by the remote host') when I try to query with my script, but if I just go to that URL from Chrome I get a JSON response no problem.. Any ideas why this is happening?
Are both of these NPM databases? It's possible that the custom schema on some of the other databases (NTA flow database, or FSM 'firebird' database) have security around direct access which is blocking your access requests.
Check the database user you're trying to connect as has the correct permissions on the database itself, it could be a simple authentication problem.