MSSQL Monitor (null) after password reset

[jeffersjw]

I changed the SA password on a MSSQL Server monitor and it is coming up as (null) even after recreating it several times. The SA password works and the monitors look the same as existing servers that work. The instance is local.

Here is an example:

check_xi_mssql_server!-U 'sa' -P '*********' -p 1433 --averagewait --warning 20 --critical 30

Any help appreciated. Thanks.

[jeffersjw]

I had a special character in the password and it seems that Nagios saw it as a variable. Changing it resolved the issue.

The character was a $

[tmcdonald]

Yea, you need to properly escape characters when dealing with just about anything on Linux. For dollar signs I believe the proper escape is \\$$