I have a dev instance of SQL Server 2008 running on a Windows 2003 virtual private server that I can access without problems from SSMS running on my laptop, connected to my wireless network at home.
But, when I take the laptop to my office and connect to the wireless network there I cannot access the database server from SSMS - the connection to the database times out. To connect I need to RDP into the VPS and run SSMS on the remote server.
I've spoken to the admins running the wireless network at the office and ports 1433 and 1434 are open and I shouldn't have any problems.
One of the obvious differences between the two wireless networks is that at home I'm using WPA2 while the office network is still set up with WEP. Is it possible for this to be causing problems?
I'm running Windows 7 Ultimate x64 SP1. The server is Windows Server 2003 R2 x63 Std. Ed. The database is SQL Server 2008 Web Edition (64 bit) 10.0.1600.22.
Any help (thoughts on what could be wrong, or how I can go about troubleshooting this) appreciated.