DB-Lib error message 20002, severity 9:

[gselvakumar]

Hi,
We are monitoring MSSQL servers. Few MSSQL servers are windows authenticated only there is no SQL authenication on those servers.For that we are created AD user iD:Domain\xxxxxxx for those servers .But we are getting error as mentioned below.

Code: Select all

COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H xxxxxxxxx -U 'Domain\xxxxxxx' -P 'xxxxxxx' -T 'master' -I BKUPEXEC --time2connect --warning 1 --critical 5
OUTPUT: DB-Lib error message 20002, severity 9:
Adaptive Server connection failed

Is this any access issue bcoz when we checked with DB they said " they have created the Id that you asked and you have all access to login to the server".But when we tried taking RDP we unable to do we are getting "connection denied to the user"
Anything we are missing.
Can any one pls help us with this.

[bwallace]

I see this issue was addressed here https://support.nagios.com/forum/viewto ... 0&p=180770 but was abandoned. We need to find out exactly what is issuing the "...connection failed" error. An nmap scan against this host conducted from the Nagios machine is a good place to start. Run namp <host.com or IP address> and post the output here.

Additionally, you could further test by not using the plugin, but by using FreeTDS as described in the link below. If this fails, then i would not expect the plugin to work either. Try this out, if applicable, and let us know of the outcome, thanks.
https://github.com/pymssql/pymssql/blob ... cs/faq.rst

[rkennedy]

As you already have a thread open for this @ https://support.nagios.com/forum/viewto ... 15#p186415 - please continue the discussion there.

Take what @bwallace mentioned into consideration and we will continue the discussion where you originally opened the thread.

In the future, please do not open multiple threads pertaining to the same issue as it only creates more work for us.