0

We have a MSSQL database configured in a cluster (fail-over). It's working fine for its intended purpose, but we can't seem to monitor availability via OpsView:

check_tcp -H $HOSTADDRESS$ -p 1433

The opsview status for this is Critical:

Connection refused

Is there a way to traceroute to a specific port and rule out rejections from a firewall?

jldugger
  • 14,602

1 Answers1

0

telnet is an excellent tool for opening a tcp connection to a random port: telnet localhost 1433, assuming something is on the other end you should get:

Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.

nc (netcat) is also a very handy tool, you can run it on listen mode on one side and connect mode on the other and see if traffic is passing. It will also do udp connections as well.

Stick
  • 658