Nagios Support Forum

MSSQL Deadlocks Per Sec COMMAND: /usr/local/nagios/libexec/check_mssql_server.py -H 192.168.0.142 -U 'user' -P 'password' -p 1433 --deadlocks --warning 20 --critical 30 OUTPUT: SQL Server message 297, severity 16, state 1, line 1: The user does not have permission to perform this action. DB-Lib erro...

Hello, We are having difficulty configuring the proper permissions to monitor Wait times and Deadlocks for MSSQL (via the check_xi_mssql_server script). The 'MSSQL Connection Time' portion of check_xi_mssql_server script is working properly. Presently, we have granted the Nagios SQL account to have ...