Check_MSSQL_Server.py plugin not function

[gm_rajkumar]

I have tried the check_mssql_server.py its not working properly, getting CRITICAL:Unable to access SQL Server message.
I have cross checked with check_mssql and check_mssql_database.py to connect the server, its working fine. please check the plugin or let me know if any changes required..

Regards,
Raj.

[lmiltchev]

Can you run your check command in a command line and show us the output?

[gm_rajkumar]

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.

Regards,
Raj.

[nscott]

Ah yes, I had found a bug in that, please download this:

http://support.nagios.com/forum/downloa ... hp?id=1579

And use the plugin inside of that one.

[gm_rajkumar]

Hi,

I have removed the old plugin and tried this new one, it returns the same issue.
Could you please check this once.

CRITICAL:Unable to access SQL Server.


Regards,
Raj.

[scottwilkerson]

Locking ticket as it is also being worked via email support