Situation: The client just installed SQL on Windows 2016 server. The users can’t access SQL database because of time out.
Troubleshooting:
- The SQL server is configured as workgroup with public network while most workstations and server are in domain network.
- 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.
- When checking the DNS Manger, we find the the SQL serer is not registry the A record.
- 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.