Using New Network Connection, I created a VPN connection to a Windows Server hosting SQL Server at a remote IP address. The status shows connected and I can see several thousand bytes have been exchanged. See attached file.
My problem is that if I go to My network places, Entire Network, Microsoft Windows Network, the server I connected to is not visible. I have a similar problem from SQL Server Management Studio running on my local PC. When I browse for servers, I cannot see the remote server on the VPN network.
Also, while the VPN connection is active, if I attempt to browse the internet, I see packets moving over the VPN network, but I do get a 404 screen instead of the expected web page. As soon as I disconnect the VPN, then my internet browser works fine.
My goal is to connect to the remote SQL Server and do some administrative work from Management Studio running on my local machine. Any ideas how to get this working?
Start Free Trial