当前位置: 动力学知识库 > 问答 > 编程问答 >

networking - SQL Server Can not Connect via Server Name

问题描述:

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.

分享给朋友:
您可能感兴趣的文章:
随机阅读: