I'm VPNed into the office which has a SQL Server. I'm running IIS 7 on my local machine (at home) to serve an asp.net 2.0 web application. If I put localhost as the my db server, aspx pages load fine (but no db connectivity since I'm not running SQL Server). If I point to the remote server, my app never loads. Even pages that don't require db connectivity!
This project works fine when I'm at the office.
Any ideas?
Thanks
If it's a connectivity problem with the db, you'd eventually get a timeout exception. Does the app test the db connection in a master page, or global.asax? That might explain the wait on non-db-connected pages.
You're using a trusted connection for management studio, which means you're connecting via the user account you used to authenticate the vpn.
Your asp.net pages do not run via your user account. They run as Network Service or something similar, and so the trusted connection fails.
The VPN is causing an IP conflict somewhere between the local and remote network, and so your http request to view the page doesn't know where to go.
Might be something specific between openVPN and SQL Server.
See here.