MSSQL Database & Server Configuration Wizards

[aap]

Hi,

I am running Nagios XI 1.7 on Centos. I am trying to configure monitoring for SQL Servers using the MSSQL Database & Server Configuration Wizards however, each time I try, I receive the message "CRITICAL:Unable to access SQL Server".

I am using the correct previleges to access the servers and databases. I have also specified the port numbers the instances are running on. I think the problem might be related to the instance names and ports being used. I have tried different hostnames by specifying the instance name after the hostname etc... Does anybody have any experience with these two Config Wizards?

Any assistance is appreciated.

[nscott]

aap,

The best way to determine proper credentials is dropping to the command line and running the plugin. Also, there was a bug in the older plugin that caused it to ignore the port, which as since been fixed. If you could uninstall, redownload and reinstall both the wizards, that should fix the port bug.

So, at the command line at /usr/local/nagios/libexec:

Just to be sure lets do a:

grep Version check_mssql_server.py

Should show at least version 1.1.0, if not then the plugin is out of date.

Moving on,

./check_mssql_server.py -H <SQL ADDRESS> -p <port> -U <user with select on master> -P <password for user>

Now the trickiest part of the previous is finding the proper <SQL ADDRESS>. I test this on SQL 2000, 2005 and 2008 and there wasn't really a common naming scheme among them. Sometimes it was <IP ADDRESS>, other times it was <IP ADDRESS>/<INSTANCE NAME>, sometimes it was a backslash. So you'll need to find out what your particular install is using.

[aap]

nscott,

Installing the latest version of check_mssql_server.py fixes the problem. The host IP address and the port number was sufficient to connect to the db instance.

Thanks again.

[nscott]

Cool,

Thanks for letting me know that was the fix.