Paul Grenyer wrote:
Hi all
I've VritualBox running a Win 2003 Server on my 64bit Ubuntu 9.10 desktop installation. And that in turn is running Microsoft SQL Server.
I can access SQL server from my ubuntu desktop as http://win2003server:1433.
But I want to be able to access it is http://localhost:1433, as if it was actually running on ubuntu.
So what I want to know is, is there a way to forward all localhost:1433 traffic automatically to win2003server:1433? Is there a better solution?
I don't know if this is the best solution, but I think it would work.
Port forwarding using SSH.
E.g. http://www.ssh.com/support/documentation/online/ssh/adminguide/32/Port_Forwa... or google port forwarding with SSH
A SSH Client for windows is PUTTY http://www.chiark.greenend.org.uk/~sgtatham/putty/ For linux it's ssh or sshd (I think) provided by the Openssh-client and openssh-server packages.
You'd need to run ssh on both the Linux side and the Windows side. The snag in this I think is that PUTTY is a ssh client and I think what you need on the Windows side is a server. However, ISTR that it's possible to run SSH backwards, and have the server program acting as a "receiver", and the client as a "sender".
Alternatively to Putty, you could perhaps install and run Cygwin on the Windows end, this may allow you to run the ssh server on windows, and a ssh client on the Linux end.
I don't know if you can achieve any of this with IPTables.
Hope that helps in some way! By the way, why don't you want to access the server as http://win2003server:1433?
Regards Steve