MSSQL Query WIZARD

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
bashar.abed
Posts: 153
Joined: Tue Oct 11, 2016 1:34 am
Location: Ramallah West Bank Palestine
Contact:

MSSQL Query WIZARD

Post 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
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: MSSQL Query WIZARD

Post by scottwilkerson »

You will need to modify the services to escape special chars such as $

https://support.nagios.com/kb/article.php?id=580
Former Nagios employee
Creator:
ahumandesign.com
enneagrams.com
Locked