Accessing SQL with the PC name not the IP

Posted by Cornelius on Server Fault See other posts from Server Fault or by Cornelius
Published on 2012-12-06T12:36:10Z Indexed on 2012/12/06 17:07 UTC
Read the original article Hit count: 257

Filed under:

sql-server-2012

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.

Related posts about sql-server-2012

SQL SERVER – 2012 – All Download Links in Single Page – SQL Server 2012

as seen on SQL Authority - Search for 'SQL Authority'
SQL Server 2012 RTM is just announced and recently I wrote about all the SQL Server 2012 Certification on single page. As a feedback, I received suggestions to have a single page where everything about SQL Server 2012 is listed. I will keep this page updated as new updates are announced. Microsoft SQL… >>> More
SQL Server 2012 edition comparison details are published

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Interesting stuff, particularly if you're doing BI. BISM tabular and Power View will not be in Standard Edition, only in the new - presumably more expensive - Business Intelligence Edition. That kind of makes sense as you need a fairly pricey edition of SharePoint to really get all the benefits… >>> More
Six in Six - SQL Server 2012 Webinars

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
We're running six webinars over the next six months covering our experiences with SQL Server 2012 and customer deployments. I'm presenting the first on upgrading to SQL Server 2012 next month, subsequent sessions will be delivered by colleagues: NOVEMBER: SQL Server 2012 Upgrade Approach… >>> More
MCSE and MCSA makes a return to the world of certification..... but not as you know it.

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Quick announcementMicrosoft Learning today announced the certification tracks for the upcoming SQL Server 2012 exams.You begin by acheiving the MCSA - Microsoft Certified Solutions Associate (Not to be confused by the old Microsoft Certified System Administrator)If you are starting out this includes… >>> More
SQL SERVER – Developer Training Kit for SQL Server 2012

as seen on SQL Authority - Search for 'SQL Authority'
Developer Training Kit is my favorite part of any product. The reason behind is very simple because it give the single resource which gives complete overview of the product in nutshell. A developer can learn from many places – books, webcasts, tutorials, blogs, etc. However, I have found that… >>> More

Developer IT