Monitoring servers over SSH tunnels?
loxybjorn
Posts: 2
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
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
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.
Redgate Foundry