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
MSSQL Query WIZARD
-
- Posts: 153
- Joined: Tue Oct 11, 2016 1:34 am
- Location: Ramallah West Bank Palestine
- Contact:
-
- DevOps Engineer
- Posts: 19396
- Joined: Tue Nov 15, 2011 3:11 pm
- Location: Nagios Enterprises
- Contact:
Re: MSSQL Query WIZARD
You will need to modify the services to escape special chars such as $
https://support.nagios.com/kb/article.php?id=580
https://support.nagios.com/kb/article.php?id=580