Cannot connect to SQL running on a VPN Client, watchguard 1250e and Watchguard VPN CLient
Posted on 2009-04-03
We have a client VPN server that simply runs Win XP pro, all updates. On this server is a master SQL DB that our program accesses. The program is installed on 15 to 20 computers in this customers office. The reason we have a VPN client installed on this server is because we use SQL replication to update that DB with ours. This all works fine, and the VPN seems to work perfectly. The problem is when we turn on the VPN the customer's computer can no longer access the SQL DB on our Server. Shut it off and everything works fine, but we lose our connection for replication. I have verified the packets are simply being ignored when the VPN is turned on. Packets leave the customers workstations and never get a reply. On the server there is no incoming packets from that workstation. I used WireShark to watch the packet traffic. UDP Port 1434 is open on the server with and without the VPN being on. I have been on the phone with Watcguard to their engineers and so far no-one has come up with a solution.