Page 1 of 1

MSSQL Query WIZARD

Posted: Sun May 27, 2018 6:50 am
by bashar.abed
Hi,

We have nagios XI version 5.3.14 VM machine and used nagios Wizard configuration to check MSSQL Query for DB server as below, i saw the error what is the problem

[root@nms ~]# /usr/local/nagios/libexec/check_mssql -H 10.x.x.194 --username aaa --password "1234" --database master --instance SQL-CON1\\SQLPROD1,1434 --query "select+1" --result "Expected result" --decode --warning 50 --critical 200 --querywarning 50 --querycritical 200 --result Expected result
CRITICAL: Could not connect to 10.x.x.194\SQL-CON1\SQLPROD1,1434 as aaa.

Thanks

Re: MSSQL Query WIZARD

Posted: Tue May 29, 2018 8:27 am
by scottwilkerson
You will need to modify the services to escape special chars such as $

https://support.nagios.com/kb/article.php?id=580