<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=547282220-19122005><FONT face=Arial
size=2>You could either use a plugin that connects to the MSSQL server port
(1433 by default) and check the response.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=547282220-19122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=547282220-19122005><FONT face=Arial
size=2>Or </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=547282220-19122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=547282220-19122005><FONT face=Arial
size=2>There are a few plugins that check to see if a result can be obtained
from an actual query against mysql, you could adapt that for
MSSQL</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=547282220-19122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=547282220-19122005><FONT face=Arial
size=2>Or</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=547282220-19122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=547282220-19122005><FONT face=Arial
size=2>You could use a plugin that will check your website (a page that uses a
database lookup) and check to see if the page returns ok or
not.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=547282220-19122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=547282220-19122005><FONT face=Arial
size=2>--Dennis</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> nagios-users-admin@lists.sourceforge.net
[mailto:nagios-users-admin@lists.sourceforge.net] <B>On Behalf Of
</B>Jason<BR><B>Sent:</B> Monday, December 19, 2005 1:10 PM<BR><B>To:</B>
Nagios List<BR><B>Subject:</B> [Nagios-users] SQL Server
monitoring<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial size=2><BR>Northern Valley Commu<FONT
face="Times New Roman" size=3>Recently, we had a server issue with one of
MSSQL servers. It never went <BR>down, but it did reject any type of
connection that would be sent to it. <BR>All websites that tried to conenct to
a database on that server failed. <BR>They all showed RunTime errors. We
have nagios set up to monitor if the SQl <BR>servers are physically down, but
is there a way to have nagios check the <BR>connectivity of a server that is
up to see if it is still accepting <BR>connections?<BR><BR>Thanks for your
help.<BR><BR>Thanks<BR>Jason B.<BR>Hosting Technician<BR>Portal Web
Hosting<BR>Northern Valley Communications
</FONT>nications</FONT></DIV></BLOCKQUOTE></BODY></HTML>