SQL Server time out because of name resolution

Situation: The client just installed SQL on Windows 2016 server. The users can’t access SQL database because of time out.

Troubleshooting:

  1. The SQL server is configured as workgroup with public network while most workstations and server are in domain network.
  2. If we ping SQL server host name, it takes 4 to 5 second to reply. If we ping the SQL server by IP, it takes just second.
  3. When checking the DNS Manger, we find the the SQL serer is not registry the A record.
  4. We fix the problem by add statics DNS A for the SQL server. Run ipconfig /flushdns on workstation, we can access the SQL database without any issues.

Published by

Bob Lin

Bob Lin, Chicagotech-MVP, MCSE & CNE Data recovery, Windows OS Recovery, Networking, and Computer Troubleshooting on http://www.ChicagoTech.net How to Install and Configure Windows, VMware, Virtualization and Cisco on http://www.HowToNetworking.com

Leave a Reply