DB LB ERROR OF MSSQL monitoring

[gselvakumar]

Hi,

Please help with error given below

COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WSRCPdfsFOE010.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: 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

COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WUSvCPLdLdfd010.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: SQL Server message 18456, severity 14, state 1, line 1:
Login failed for user 'nagios'.
DB-Lib error message 18456, severity 14:
General SQL Server error: Check messages from the SQL Server
DB-Lib error message 20002, severity 9:
Adaptive Server connection failed

COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WUdgfdsgX00.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: 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

COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WdsgfsdddE01.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: <class 'pymssql.InterfaceError'>
Caught unexpected error. This could be caused by your sysperfinfo not containing the proper entries for this query, and you may delete this service check.

[rkennedy]

COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WSRCPdfsFOE010.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: 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

From the Nagios machine, what is the full output of nmap WSRCPdfsFOE010.fossil.com?

COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WUSvCPLdLdfd010.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: SQL Server message 18456, severity 14, state 1, line 1:
Login failed for user 'nagios'.
DB-Lib error message 18456, severity 14:
General SQL Server error: Check messages from the SQL Server
DB-Lib error message 20002, severity 9:
Adaptive Server connection failed

Looks like you have the wrong credentials.

COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WUdgfdsgX00.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: 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

From the Nagios machine, what is the full output of nmap WUdgfdsgX00.fossil.com?

COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WdsgfsdddE01.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: <class 'pymssql.InterfaceError'>
Caught unexpected error. This could be caused by your sysperfinfo not containing the proper entries for this query, and you may delete this service check.

Can you show us the corresponding log from your SQL server?

[gselvakumar]

Hi Team,
There are few MSSQL servers which has only windows authentication only (No SQL authentication).Even DB team is using Windows authentication on these servers. So for monitoring for those servers we have created user id having windows authentication to connect to the SQL server,but when we are trying we are getting error.Is that anything we are missing?
Can anyone pls help us regarding this.

Please find below the command and the error for server

Code: Select all

/usr/local/nagios/libexec/check_mssql_database.py -H xxxxxxx -U 'xxxxxx' -P 'xxxxxxx' -T 'master' -I xxxxxxx --time2connect --warning 1 --critical 5
OUTPUT: SQL Server message 18456, severity 14, state 1, line 1:
Login failed for user 'nagios'.
DB-Lib error message 18456, severity 14:
General SQL Server error: Check messages from the SQL Server
DB-Lib error message 20002, severity 9:
Adaptive Server connection failed

Thanks
Gomathyshankar Selvakumar

[gselvakumar]

Hi,
Regarding the previous post pls let can we monitor MSSQL servers using windows authentication using MSSQL Database, MSSQL Query and MSSQL server plugin.
If not let is there any other plugin that we can use


Thanks,
Gomathyshankar Selvakumar

[rkennedy]

COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WSRCPdfsFOE010.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: 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

From the Nagios machine, what is the full output of nmap WSRCPdfsFOE010.fossil.com?

COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WUSvCPLdLdfd010.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: SQL Server message 18456, severity 14, state 1, line 1:
Login failed for user 'nagios'.
DB-Lib error message 18456, severity 14:
General SQL Server error: Check messages from the SQL Server
DB-Lib error message 20002, severity 9:
Adaptive Server connection failed

Looks like you have the wrong credentials.

COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WUdgfdsgX00.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: 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

From the Nagios machine, what is the full output of nmap WUdgfdsgX00.fossil.com?

COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WdsgfsdddE01.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: <class 'pymssql.InterfaceError'>
Caught unexpected error. This could be caused by your sysperfinfo not containing the proper entries for this query, and you may delete this service check.

Can you show us the corresponding log from your SQL server?

Can you please address these questions I asked previously? It should work fine with windows authentication, perhaps you're missing the computer or domain account name. The error is indicating the credentials are wrong.

Code: Select all

Login failed for user 'nagios'.
DB-Lib error message 18456, severity 14:

[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.

[gselvakumar]

The nmap output:

Code: Select all

[root@lussvpnagiosxi00 ~]# nmap xxxxxxxxxxx

Starting Nmap 6.47 ( http://nmap.org ) at 2016-06-16 23:27 CDT
Nmap scan report for xxxxxxxx (xxxxxxxxxx)
Host is up (0.13s latency).
Not shown: 981 closed ports
PORT      STATE SERVICE
80/tcp    open  http
135/tcp   open  msrpc
139/tcp   open  netbios-ssn
443/tcp   open  https
445/tcp   open  microsoft-ds
515/tcp   open  printer
1311/tcp  open  rxmon
3527/tcp  open  beserver-msg-q
5633/tcp  open  beorl
5666/tcp  open  nrpe
6101/tcp  open  backupexec
6106/tcp  open  isdninfo
8000/tcp  open  http-alt
8002/tcp  open  teradataordbms
8081/tcp  open  blackice-icecap
10000/tcp open  snet-sensor-mgmt
49152/tcp open  unknown
49153/tcp open  unknown
49154/tcp open  unknown

Nmap done: 1 IP address (1 host up) scanned in 9.65 seconds

[gselvakumar]

https://github.com/pymssql/pymssql/blob ... cs/faq.rst

Code: Select all

[root@lussvpnagiosxi00 ~]# tsql -H xxxxxxx -p 1433 -U domain/xxxxxx -P Welcome123 -D tempdb
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
Default database being set to tempdb
Error 20009 (severity 9):
        Unable to connect: Adaptive Server is unavailable or does not exist
        OS error 111, "Connection refused"
There was a problem connecting to the server

[tgriep]

Try using a forward slash in the username like the example below.

Code: Select all

'Domain/xxxxxxx' 

If that doesn't work, you will have to create an SQL local account on the MSSQL server.

[gselvakumar]

Hi,

I tried forward slash but it is not working.

These servers are not having SQL authentication.They are having windows authentication only ,even Database team are windows authentication for these servers.