Hyperspin Presales & Support

[Specialty]

Hi,

It would be great if you could make it possible to do MSSQL server checks.

Specialty.

[choonkeng]

Dear sir/madam,

Thank you for your interest in our service.

Our system already supports MySQL check. Just make sure that your MySQL server listens on TCP port 3306 (not just on unix socket) so that we can monitor over the internet.

Please let us know should you have any further questions.

Thank you.

[Specialty]

Yes MySQL works perfect.

But what with MSSQL (Microsoft SQL server)?

[choonkeng]

Sorry for overlooking your question.

We do not support direct MSSQL checking yet. However, you can write a simple script (ASP etc) to connect to MSSQL, perform a simple query and output "success" if everything goes well. You can use our service to check the output of that script to know if your MSSQL is working. In fact, you can even check multiple MSSQL servers with this approach.

More details - http://www.hyperspin.com/faq.php?action=showanswer&faqid=24

Please let us know should you have any further questions.

Thank you.

[choonkeng]

In fact, you can still use our TCP port test to check the port your MSSQL listens on (eg. 1433). We will try to connect to the port (to determine if it is open) but do not check at MSSQL protocol level.

Quite a number of our customers find it sufficient to monitor their MSSQL this way because most of the time when MSSQL fails, the port is just dead.

Thank you.