如何解决 sql server 2000 中的连接问题[外文翻译].doc

中文译文：4900字    10页
英文原文：16800字   12页

如何解决 SQL Server 2000 中的连接问题
Chris Tull, Microsoft Help and Support
这一篇文章能帮助你解决微软 SQL 伺候器 2000 的连接性问题。这一篇文章包含你能拿帮助解决你的连接性问题的通常连接性问题和步骤的描述。
SQL Server的例证和客户端申请之间的沟通的 SQL Server 2000 支持一些方法。如果你的客户申请和SQL Server的例证在相同的计算机上住, Microsoft Windows 处理之间的沟通 (IPC) 成份（像是当地的命名管或者被分享的记忆记录）用来沟通。 然而, 当客户端申请和SQL Server的例证在不同的计算机，网络IPC（像是TCP/IP上住的时候或者命名管道）用来沟通。
SQL Sever 2000 使用网络控件库（一个DLL）与一个特别的网络记录沟通。 一双相配网络控件库一定在客户计算机和服务器计算机上是活跃的支援你想要使用的网络记录。 举例来说，如果你想要使一个客户申请能够与通过TCP/IP的一个 SQL Server的特定例证沟通, 客户TCP/IP套接字网络控件库 (Dbnetlib.dll) 一定配置成在客户计算机上对伺候器连接。 同样地, 服务器TCP/IP套接字网络控件库 (Ssnetlib.dll) 一定在伺候器计算机上听。 在这一个情节中, TCP/IP协议堆栈一定是装置在客户计算机和服务器计算机。

How to troubleshoot connectivity issues in SQL Server 2000
Chris Tull, Microsoft Help and Support
This article can help you to resolve connectivity problems with Microsoft SQL Server 2000. This article contains descriptions of common connectivity problems and the steps that you can take to help resolve your connectivity problems.
SQL Server 2000 supports several methods of communication between the instance of SQL Server and the client applications. If your client application and the instance of SQL Server reside on the same computer, Microsoft Windows interprocess communication (IPC) components, such as local named pipes or the Shared Memory protocol, are used to communicate. However, when the client application and the instance of SQL Server reside on different computers, a network IPC, such as TCP/IP or named pipes, is used to communicate.
SQL Server 2000 uses Net-Library, a DLL, to communicate with a particular network protocol. A matching pair of Net-Libraries must be active on the client computer and the server computer to support the network protocol that you want to use. For example, if you want to enable a client application to communicate with a specific instance of SQL Server across TCP/IP, the client TCP/IP Sockets Net-Library (Dbnetlib.dll) must be configured to connect to the server on the client computer. Likewise, the server TCP/IP Sockets Net-Library (Ssnetlib.dll) must listen on the server computer. In this scenario, the TCP/IP protocol stack must be installed on both the client computer and the server computer.