Monitoring servers over SSH tunnels?

loxybjornloxybjorn Posts: 2
edited December 4, 2008 11:48AM in SQL Monitor Previous Versions
Hi,

We access a bunch of SQL Servers over SSH based TCP tunnels which makes the adress for SSMS and other tools "localhost", port "X" (the SSH client (PuTTY in our case) listens on localhost, port X and forwards connections to some other address, port 1433). This works very well for SSMS etc (and SQL Compare). I have not been able to make it work with SQL Response however. Is it possible? If so, how?

Regards,
/Björn Bylander

Comments

  • Hi Bjorn,

    SQL Response depends on WMI when connecting to the servers it is monitoring, WMI/DMOM uses a range of ports so setting up SSH to listen on all of these ports and forward would be a real pain.

    I am guessing the SQL Servers are in a different domain to your Alert Repository/Client which we currently don't support.

    You could try installing the Alert Repository in the same domain/site as your SQL Servers.

    I hope this helps.
    Matthew Flatt
    Redgate Foundry
Sign In or Register to comment.