I recently setup a new server for use with SQL. When I tried to connect via SSMS remotely, it failed. When I pinged it, it is pinging localhost, what is going on here? Please let me know if more details will help. It is Windows Server 2008.
C:\>ping 0x7F000001
Pinging 127.0.0.1 with 32 bytes of data:
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Ping statistics for 127.0.0.1:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
OK, I feel like I'm on candid camera, but I'll take a whack at it.
I want to introduce a domain name to the equation, so I'm going to use example.com in lieu of actually knowing what your local domain is.
You have a server whose nodename is 0x7f000001. Its FQDN is 0x7f000001.example.com. 0x7f000001 is also a valid IP address, represented also as decimal 2130706433, 0b1111111000000000000000000000001, or dotted-quad 127.0.0.1.
Your problem is that when you type
ping 0x7f000001
, the ping program evaluates that as an IP address instead of a hostname. The ping program cannot read your mind, it does not know that the valid IP address you told it to ping is also a hostname, and it evaluates whether it is an IP first.Imagine if you will that you created a hostname 127, put it in the zone 0.0.1.example.com, and make example.com your default search domain. According to your logic, it should then be valid to type
ping 127.0.0.1
and have ping not use the IP 127.0.0.1 but instead use the A record pointed to by the FQDN 127.0.0.1.example.com, which is silly.Short of recompiling
ping
to behave the way you think it should, try pinging the FQDN 0x7f000001.example.com.0x7F000001 is the hexadecimal representation of 127.0.0.1 - unless I'm missing something here...
http://www.kloth.net/services/iplocate.php
If you give it a domain then it should work e.g.
ping 0x7F000001.lan
otherwise ping is assuming that it's a hexadecimal number to convert into an IP address