MS SQL Monitoring

[jbmaliwat]

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

[nscott]

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.

[jbmaliwat]

It still goes the same error

[nscott]

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.

[jbmaliwat]

Hi Sir,

Correction: jbmaliwat sir..

Ok sir, I will try this one. Thank you

[nscott]

Sorry about the name, my mistake.