问题描述:

I've been stuck for this problems for almost half day now. Here the condition :

Let say I have 2 SQL Server 2000 in my network :

  1. sungai (192.168.1.63)
  2. serverpc (192.168.1.200)

One of client PC can not connect to serverpc using "Computer Name" but works fine using IP Adress (ODBC and Query Analyzer), let say this PC as "Problem PC". 20 clients can connect to serverpc using Computer Name, just this "Problem PC" can't. "Problem PC" can connect to sungai using Computer Name and IP. I have checked nslookup and found no result using serverpc in my dns. This network using 2 router with 1 Subnet and Gateway.

If anyone need more details, just post in comment.

I'm really appreciate for your help.

网友答案:

I'm so sorry for asking. The problem is with Client PC. Somehow there is sql server alias with name "serverpc" in this client PC. I just remove it from "Client Network Utility" => "Alias" and works fine now.

相关阅读:
Top