<div dir="ltr">Pradeep<div><br></div><div>There are two ways to do the monitoring. One way is to run a script on the MS-SQL server that reports back to the Xymon server. This can be achieved by one of the VBS scripts on the Xymonton Plugins page: <a href="https://wiki.xymonton.org/doku.php/monitors">https://wiki.xymonton.org/doku.php/monitors</a></div><div><br></div><div>The other way is to have the Xymon server connect to the MS-SQL server using a network-based SQL connection. For this, have a look at this page: <a href="http://sourceforge.net/projects/hobbit-perl-cl/">http://sourceforge.net/projects/hobbit-perl-cl/</a>, and this one: <a href="http://heinelt.info/index.php?option=com_remository&Itemid=24&func=fileinfo&id=13">http://heinelt.info/index.php?option=com_remository&Itemid=24&func=fileinfo&id=13</a>.</div><div><br></div><div>You could probably do both. I've not tested any of these, and I have no idea how well, or even if, they work.<br></div><div><br></div><div>If all you want to do is check that TCP/1433 is open, then you can do this with a network check. As there are no network checks defined for MS-SQL, you can create one, by adding the following to protocols.cnf:</div><div><br></div><div>[mssql]</div><div> port 1433</div><div><br></div><div>Then, in hosts.cfg, add an "mssql" tag into the list of tags, like so:</div><div><br></div><div>192.168.1.10 <a href="http://mssqlserver.example.com">mssqlserver.example.com</a> # testip dialup mssql</div><div><br></div><div>This should create an "mssql" column with a red or green dot depending on whether Xymon can connect on TCP port 1433.</div><div><br></div><div>Cheers</div><div>Jeremy</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 29 July 2015 at 22:05, Pradeep Badiger <span dir="ltr"><<a href="mailto:pbadiger@enstage.com" target="_blank">pbadiger@enstage.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><font face="arial" size="2"><p style="margin:0;padding:0;font-family:arial;font-size:10pt;word-wrap:break-word">Hi Team,<br><br> Can you please help me out to monitor the Microsoft SQL with details need your guidelines for configuring XYMON.</p>
<p style="margin:0;padding:0;font-family:arial;font-size:10pt;word-wrap:break-word"> </p>
<p style="margin:0;padding:0;font-family:arial;font-size:10pt;word-wrap:break-word"><span style="font-size:10.0pt;font-family:'Arial',sans-serif;color:#1f497d">Thanks & Regards,<br>Pradeep B<br></span></p>
<p style="margin:0;padding:0;font-family:arial;font-size:10pt;word-wrap:break-word"><strong><span style="font-size:10.0pt;font-family:'Arial',sans-serif;color:#0070c0">Sr.System Admin-Linux</span></strong><span style="font-size:11.0pt;font-family:'Calibri',sans-serif;color:#1f497d"><br></span><span style="font-size:10.0pt;font-family:'Arial',sans-serif;color:#4a442a">Information Technology Department</span><span style="font-size:18.0pt;font-family:'Georgia',serif;color:#fc7404"><br>en</span><span style="font-size:18.0pt;font-family:'Georgia',serif;color:#0070c0">Stage</span><span style="font-size:9.0pt;font-family:'Arial',sans-serif;color:#7f7f7f"><br>…………………………………………………………………………………………….</span><span style="font-size:9.0pt;font-family:'Arial',sans-serif;color:#5e5e5e"><br>Cell: <a href="tel:%2B91%209845719456" value="+919845719456" target="_blank">+91 9845719456</a>; Desk: <a href="tel:%2B91%2080%204342%208197" value="+918043428197" target="_blank">+91 80 4342 8197</a> | </span><span style="font-size:11.0pt;font-family:'Calibri',sans-serif;color:#1f497d"><a href="http://www.enstage.com/" target="_blank"><span style="font-size:9.0pt;font-family:'Arial',sans-serif;color:#0563c1">http://www.enstage.com</span></a></span></p>
</font>
<pre>This message contains confidential information and is intended only for the individual named or entity to whom they are addressed. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission.</pre><br>_______________________________________________<br>
Xymon mailing list<br>
<a href="mailto:Xymon@xymon.com">Xymon@xymon.com</a><br>
<a href="http://lists.xymon.com/mailman/listinfo/xymon" rel="noreferrer" target="_blank">http://lists.xymon.com/mailman/listinfo/xymon</a><br>
<br></blockquote></div><br></div>