MSSQL Server monitoring problem

[surachai.ch]

Hi,

I have run MSSQL Database and Server monitoring by using Monitoring wizard. The Database can be monitored without a problem but for MSSQL server it show status "Critical with "10.4.14.87\MSSQLSERVER:1433" in Status Information.

I have tested run check_mssql_server.py at /usr/local/nagios/libexec and it shows error below.

[root@nagiossrv libexec]# ./check_mssql_server.py -H '10.4.14.87' -U 'nagios' -P 'Tcc@nagios' -I 'MSSQLSERVER'
10.4.14.87\MSSQLSERVER
CRITICAL:Unable to access SQL Server

Note: I have already installed the prerequisites for the MSSQL wizards and plugins as described in document (Nagios XI – Installing MSSQL Wizard Prereqs).

Any suggestion on this issue.

Regards,
Surachai C.

[nscott]

Surachai,

There was a bug in the plugin. You can either redownload and reinstall the wizard or delete the check_mssql_server.py plugin in your Nagios XI /usr/local/nagios/libexec directory and replace it with the plugin attached to this post:

[surachai.ch]

Hi,

It works now. Thank you for your suggestion.

Regards,
Surachai C.

[scrantic]

Glad I searched for this, Was doing my head in couldn't figure out what I'd done wrong.

Is/Will MSSQL 2012 be supported by the plugin?

[gm_rajkumar]

I have tried to remove the wizard, plugins but still im getting the message.
I have checked with ./check_mssql_server.py -H <IP> -U Username -P Password ... its not working fine. Im getting this CRITICAL:Unable to Connect SQL Server message . please check let me know where is the exact issue on this.

Regards,
Raj.

[gm_rajkumar]

i tried to check_mssql_database.py -H hostname -U user -P password -T table -p port, it shows connected. please let me know is it related to plugin issue (check_mssql_server.py) or command line issue? I have updated the command line output for your reference. I have tried with mssql_database.py plugin i can able to connect the SQL server and Database. So there is no issue on the user/password.

Please find the below result.

[root@monitoring libexec]# /usr/local/nagios/libexec/check_mssql_server.py -H '172.16.4.12' -U 'sa' -P 'ABC@123$' -I 'MSSQLSERVER'
CRITICAL:Unable to access SQL Server.

--------------------------------------------------------------------------------
[root@monitoring libexec]# /usr/local/nagios/libexec/check_mssql_database.py -H '172.16.4.12' -U 'sa' -P 'ABC@123$' -T 'WSS_Content_80' -p 1433 --datasize -w 80 -c 90
CRITICAL:Size of database is 3135744KB|Size_of_database=3135744KB;;;;
[root@monitoring libexec]#

Let me know if you need further details on this.


Thanks!
Regards,
Raj.

[nscott]

Could you rephrase that? I don't think I quite understand what the issue is.

[nscott]

Also, this is indeed tested and working with 2012.