We are upgrading from sql server 2005 to sql server 2008 and windows server 2008 R2.
New server is behind a firewall, we have 30 or so windows XP machines, that will require the port 1433 to be open, because they are old Windows applications that require a direct connection.
Previously the old sql server was on two network, one of which was a private network, and we had a vpn server that would put each of these client machines on that private network. This setup is no longer available for us.
Is there a way to tunnel all these client machines so that we do not have to punch holes in the firewall?