I have a rented dedicated windows server on a public ip that is acting as a SQL Server and VPN server. I need to connect to this server via computer name to get replication in place. I cannot use an ip address due to this issue:
So, due to this, we are going the VPN route.
That is my primary issue:
After I am connected to this server's vpn, I can connect to SQL Server using the ip address but I cannot connect by the computer's name as you can see below...
Right now, there is no hardware firewall on it since I had it removed to test this issue.
I am running Windows 2008 Enterprise Server as the VPN server.
I am not sure if the route print will help any from the workstation trying to connect but here is the info:
IPv4 Route Table
Active Routes: Network Destination Netmask Gateway Interface Metric 10.0.0.0 255.0.0.0 10.0.0.1 10.0.0.2 21
10.0.0.2 255.255.255.255 On-link 10.0.0.2 276
Any other info needed?
Thanks for the help!
========= CLARIFICATION ON A FEW THINGS #1 =========
This is the server's info:
This is the workstation that is trying to connect:
I connect to the server via "Control Panel\Network and Internet\Network and Sharing Center\Connect or Disconnect"
You can see here that I am connected:
========= CLARIFICATION ON A FEW THINGS #2 =========
I've tried to connect directly to the Sql Server as I did above but with the computers name and I couldn't get to it.
Here I am trying to net view it from the workstation and it couldn't find it: