I'm trying to get an SQL program to connect from a Windows 7 client machine connected to an SBS 2008 box via VPN. The remote machine is not connected to the domain itself. I've made the VPN a work network, and opened created Windows Firewall rules to allow the relevant ports through (the software has a custom TCP port and the standard SQL UDP port).
I know it's Windows Firewall related, because the moment I turn it off the program works, it just won't connect when it's on, even with the ports opened.
Anyone got any ideas?