Error message when check sql servers with Nagios Client Inst

[Kxfrancois]

Hi,

I am new to Nagios. We were handed this platform from our predecessor. When I look at the sql Servers, they all have the same error messages.

Unknown
SQL Server message 18456, severity 14, state 1, line 1:
Login failed for user 'SRV-Nagios-Monitor'.
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

any ideas?

Thanks,
Kerwin

[scottwilkerson]

Are we sure the user SRV-Nagios-Monitor is still valid for the server? Have we verified the credentials for the user?

[Kxfrancois]

Yes I have. I have used those credentials to logon onto the server.

[scottwilkerson]

Is this a domain user?

Does the user have rights to login to MSSQL?

Can you show the whole command nagios is running when giving these results?

[Kxfrancois]

Command View: $USER1$/check_mssql_server.py -H $HOSTADDRESS$ $ARG1$
$ARG1$: -U 'SRV-Nagios-Monitor' -P 'correct_PW' -p 1433 --pagereads --warning 20 --critical 30

I get this as a result:

[[email protected] ~]$ /usr/local/nagios/libexec/check_mssql_server.py -H 172.28.48.24 -U 'SRV-Nagios-Monitor' -P 'correct_PW' -p 1433 --pagereads --warning 20 --critical 30
SQL Server message 18456, severity 14, state 1, line 1:
Login failed for user 'SRV-Nagios-Monitor'.
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

[scottwilkerson]

Is this a domain user?

Does the user have rights to login to MSSQL?

[Kxfrancois]

Sorry about that. Yes this is a domain user and this user has rights to login to SQL.

[scottwilkerson]

for a domain user you will need to add toh domain to the username field

Code: Select all

/usr/local/nagios/libexec/check_mssql_server.py -H 172.28.48.24 -U 'DOMAIN\SRV-Nagios-Monitor' -P 'correct_PW' -p 1433 --pagereads --warning 20 --critical 30

See page 11 here:
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

[Kxfrancois]

Same result

[[email protected] ~]$ /usr/local/nagios/libexec/check_mssql_server.py -H 172.28.48.24 -U 'firstlightpower\SRV-Nagios-Monitor' -P 'correct_PW' -p 1433 --averagewait --warning 1500 --critical 2000
SQL Server message 18456, severity 14, state 1, line 1:
Login failed for user ''.
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

[Kxfrancois]

I ran through the document you sent me and I am still getting the same error message: