check_mssql_server.py - "Adaptive Server is unavailable"

[sav2880]

Good Afternoon,

Hoping someone might be able to help on this. I am attempting to run some tests using the check_mssql_server.py plugin. I've solved the permission issues, but right now, I'm getting the following error:

DB-Lib error message 20009, severity 9:
Unable to connect: Adaptive Server is unavailable or does not exist
Net-Lib error during Connection refused Error 111 - Connection refused

Has anyone seen this particular error before? I think I've gotten all of the particular prerequisites installed but I'm happy to troubleshoot with some assistance.

Thanks!

[dwhitfield]

I don't believe this is a Nagios issue. It looks like there are probably a couple of solutions at https://stackoverflow.com/questions/193 ... severity-9. By solutions, I mean that people claim to have actually solved "DB-Lib error message 20009, severity 9," rather than just suggestions.

If you run through the two fixes there and still have issues, please let us know.

[sav2880]

Maybe you can give me an assist with the solutions here and what we're seeing.

* I've checked under SQL Server configuration, and the TCP/IP port is enabled on the cluster's IP address (this is a two-node SQL failover cluster). It's not enabled on the IP addresses for each node, but I can't see why it would need to be. I've also enabled the loopback IP (127.0.0.1), but since the check is coming from the Nagios server, I would think this wouldn't necessarily apply either.

* I don't think that it's a login issue, because before we had the problem with getting this adaptive server message, I would get a message saying that permission was explicitly denied.

* No SQLEXPRESS running, just the regular MSSQLSERVER

Could it be that I need to reinstall the DBD::Sybase script?

[dwhitfield]

Ok, now I'm confused. Your initial post is talking about Microsoft SQL. Now you are talking about Sybase (owned by SAP).

To help us get to the bottom of what is going on, can you PM me your Profile? You can download it by going to Admin > System Config > System Profile and click the Download Profile (not Show Profile) button in the top right corner. If for whatever reason you cannot download the profile, please put the output of Show Profile in the thread (that will at least get us some info).

After you PM the profile, please update this thread. Updating this thread is the only way for it to show back up on our dashboard.

UPDATE: Profile received and shared with techs.

[sav2880]

Profile is attached. Thanks!

(Also, I am just as confused, although other posts I've read about getting this working talk about configuring DBD::Sybase through cpan, even though yes, that's Sybase and we're talking about MSSQL here)

[dwhitfield]

Did this ever work? If not, I suspect that just uninstalling the Sybase stuff will solve the issue.

From https://assets.nagios.com/downloads/nag ... ios-XI.pdf

perl-DBD-Sybase
– This was included on Nagios XI for implementation later. It currently is not an essential part of a default Nagios XI install. However, if you have installed other plugins that pertain to Sybase or MSSQL, it would be wise to investigate the necessity of this package for your own needs before removing it

I did a cursory inspection to see if you were using Sybase, but since you didn't mention using Sybase, I kinda assumed you weren't using it. Please let me know if I missed it in your profile.

Also, please let me know if removing the Sybase perl stuff doesn't fix your issue.


If it did work, did it stop working when you upgraded XI? I suspect that is when the Sybase stuff got installed, if so.