Unable to monitor SQL

[saar]

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 !!!!

[slansing]

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.

[saar]

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.

[slansing]

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

Admin > License Information > Enable Enterprise