Skip to main content
The 2024 Developer Survey results are live! See the results

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

3
  • This basically a situation where I need to map a plurality of addresses.... all targeting a single port (1433) to a single address (localhost) targetting multiple ports (unique jump host connections for a particular server).
    – Triynko
    Commented Feb 25, 2020 at 19:58
  • Is it possible to use other means of connecting to the jumphost than SSH? Specifically, with a VPN server this would be a simple route, or at worst iptables DNAT on the jumphost. Commented Feb 25, 2020 at 20:01
  • I figured it out. I'll write up an answer. I just used a combination of the HOSTS file and netsh interface portproxy to add the port redirects. The TRICK is that the "listenaddress" cannot be remote. It has to be local. It doesn't have to be "localhost" (127.0.0.1), but it does have to be a local address LIKE 127.0.0.0/8. So basically, use HOSTS file to force remoteAddressA onto an unused "local" address like 127.123.0.0, and then add a portproxy redirect for port 1433 on locl address 127.123.0.0 to port 5001 on localhost 127.0.0.1. That routes it through the tunnel.
    – Triynko
    Commented Feb 25, 2020 at 20:46