Accessing SQL with the PC name not the IP
- by Cornelius
I'm trying to connect to a SQL instance (default instance) on a machine. When using the IP of the machine it connects to the machine. Using the name of the machine on that machine you are able to establish a connection to the SQL instance but using the machine name on another PC the connection cannot be established. And gives the error
A network-related or instance-specific error occurred while establishing a connection to SQL Server. ... (Microsoft Server, Error: 10060)
The machine that I am trying to establish the connection from can ping the machine with the SQL instance both on the IP and on the name.
Why would this be and how can I fix it?
Edit: pinging the name does resolve the correct IP. Pinging the FQDN also works correctly.