Additional SQL Server features and topics not covered by specific categories
It looks like problem is DNS, not connectivity or firewall. You can try following in order.
- See what DNS actually does with the name:
Resolve-DnsName aka.ms
nslookup aka.ms
- Check which DNS servers the box is using:
Get-DnsClientServerAddress
ipconfig /all
Look at the configured DNS server entries. If they're empty, pointing at a dead internal resolver, or pointing at something that only serves internal zones, that's your failure.
- Test against a known-good public resolver to isolate the fault:
Resolve-DnsName aka.ms -Server 8.8.8.8
nslookup aka.ms 8.8.8.8
If 8.8.8.8 resolves it fine but your configured DNS doesn't, the problem is your DNS server / network config, not the host or the internet.
- Check the hosts file for stray entries (this explains the earlier bogus-IP behavior):
C:\Windows\System32\drivers\etc\hosts
- Flush and retry:
ipconfig /flushdns
Resolve-DnsName aka.ms