I have a server (Win 2008) and a desktop PC (Win 7) at my work behind a firewall. The server doesn't has internet connection for security (actually, it is in a remote datacenter), and the desktop PC has a Logmein client installed, so I can use this PC from my house, and connect me to the server. Now I need to connect me to the MS SQL Server in the server from a MS SQL Server client in my home, but I can't figure out how can make a remote tunnel like that... to be more explicit:
______________________________________________
| Firewall at work |
| ________________ __________________ |
| |(1) | |(2) | |
| | Win2008 Server | | Desktop Win7 | |
| | (MS SQL Srv) | <--- | (Logmein & inet) | |
| |________________| |__________________| |
|______________________________________________|
_________________ at home _________________
|(3) | |(4) |
| Linux PC | <-----> | Win 7 |
| SSH Virtual Srv | | (MS SQL Client) |
|_________________| |_________________|
I need to access from (4)'s MS SQL Client to (1)'s MS SQL Server... I think I should make a reverse ssh tunnel with Putty or something like that from (2) to (3) to open a port who redirects all incoming traffic in a certain port in (3) to (1) through (2). I don't know if really I need (3) to make the ssh tunnel, if it not to be used, should be even better. The desktop PC with Logmein and direct access to the server has a really poor internet connection, so it's really difficult to work like that.
Sorry for my bad english...