SQL2000 Management SQL7 Server appears timeout problem resolution

Servers | solving | problems

Younger brother's machine loaded with SQL2000, ready to learn, who knows in the management of other SQL7 server when the message prompts "Timeout expired", the symptom is as follows: 1, connect the local LAN server, use Enterprise The above error prompts occurred while registering the server at manager, but there was no problem using Query Analyzer, but it was a bit slow. 2. Connecting to servers on the Internet, using Enterprise Manager and Query Analyzer, all of these errors have occurred.

Finally, after a multi-party search, finally found that the original is the problem of DNS. When SQL2000 needs to get the domain name or machine name of the machine when it joins a server, it needs to be set up in the Hosts file when managing these servers. About the Hosts file on the web has a lot of information, little brother here will no longer wordy.