Nagios Support Forum

Hi,

Does anyone here encountered the same problem.
Please see below.



Can anyone help me how to solve this problem? Why it goes critical. I have already installed the agent for Windows, where my MS SQL is running.
What other things should I do, to successfully monitor my MS SQL.

Thank you,

John Benedict Z. Maliwat
Junior Technical Support Engineer
Manila, Philippines

You need to make sure your MSSQL server is allowing TCP/IP and SQL authentication.

For TCP connections this is a good tutorial to follow:

http://plutonium.cs.umanitoba.ca/ntlabs ... -home.html

If thats not fixing it, I would Google for 'MSSQL <your version of MSSQL> IP' to find more articles as it varies a little bit for each different version.

Then you'll also need to enable SQL authentication, again, here is a good reference for that:

http://eduzine.edujini-labs.com/archive ... ation.html

After that you should be able to connect to it using the credentials you specified.

It still goes the same error

jbalmiwat,

It can vary pretty significantly from MSSQL server to MSSQL server, so I"d recommed dropping down to the command line and going to /usr/local/nagios/libexec and running the plugin manually til you find the correct login credentials:

./check_mssql_server -H <IP of MSSQL> -U <user with SELECT access on master and temp> -P <password for said user> -p <port open on MSSQL server>

This is the quickest way to diagnose connectivity issues with the MSSQL database.

Hi Sir,

Correction: jbmaliwat sir..

Ok sir, I will try this one. Thank you

Sorry about the name, my mistake.