I've been getting those sharepoint errors in the event log saying it cannot connect to the SQL server. So I thought I might try to ping it and when pinging the hostname, it came back with the external IP address outside the firewall which some people call the public IP address. I can ping the internal IP but when I ping the hostname, it returns with no response.
I added an entry for the sql server to the hosts file and to the Lmhosts file. First I checked the DNS server and found the appropriate entry there so that was really puzzling.
Is there something I am missing here? Sometimes it finds the other machine and sometimes it does not. Anyone seen this before?