Nagios Support Forum

Hi All,

I am still pretty new to Nagios however I have tried debugging an issue with regards to trying to monitor MS SQL DBs via the nagios xi template.

Currently monitoring just on a server level I am able to bring back all results with no errors.

Upon setting up checks via the MS SQL DB I am presented with the following error message: CRITICAL:Unable to access SQL Server.

the username and password created for the user is a SQL authentication based user and not AD, upon doing checks on the DB itself it has sufficient access (infact more access than I would have thought required just to try and get the check running).

I have also tried to execute the test manually off the Nagios server with the following command however I get the same error:

[root@chvirmonprd03 etc]# /usr/local/nagios/libexec/check_mssql_database.py -H 10.30.29.157 -U 'nagagent' -P 'Nag2013' -I 'MSSQLSERVER' -p 1433 -T 't_entity'
CRITICAL:Unable to access SQL Server.

We are still in the POC stage upon making the purchase to go with Nagios so I would like to get this working asap as I do actually find alot of benefits with using Nagios but I just seem to be stumped with the database level monitoring at the moment.

Please help !!!!

http://assets.nagios.com/downloads/nagi ... rereqs.pdf

Take a look at the "A Gotcha" section, be sure you either use only the port, or instance name or the string will try to connect to both.

Hi Slansing,

Thanks for the reply - unfortunately our trial had run out for nagios and we were unable to get any database level monitoring working.

We are looking into our possibilities with monitoring tools - never the less thanks for the response.

If you would like, you can still enable an enterprise edition trial through the UI at:

Admin > License Information > Enable Enterprise