All right, here is the deal:
I'm connecting to a Windows 2003 Server using VPN. On this server, there is a remote SQL Server 2005 Express engine.
I can connect to the database using Visual Studio 2008.
What I can't do though, is connect to this same database with SQL Server 2005 Management Studio (Standard).
I have checked the connection info a hundred times and still nothing.
One thought: do VS ans SSMS use the same sql provider?
Note: I'm running Windows 7 RC. I had absolutely no problem using the same config under Vista.