中文譯文：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) 成份（像是當?shù)氐拿芑蛘弑环窒淼挠洃浻涗洠┯脕頊贤ā?然而, 當客戶端申請和SQL Server的例證在不同的計算機，網(wǎng)絡IPC（像是TCP/IP上住的時候或者命名管道）用來溝通。
SQL Sever 2000 使用網(wǎng)絡控件庫（一個DLL）與一個特別的網(wǎng)絡記錄溝通。 一雙相配網(wǎng)絡控件庫一定在客戶計算機和服務器計算機上是活躍的支援你想要使用的網(wǎng)絡記錄。 舉例來說，如果你想要使一個客戶申請能夠與通過TCP/IP的一個 SQL Server的特定例證溝通, 客戶TCP/IP套接字網(wǎng)絡控件庫 (Dbnetlib.dll) 一定配置成在客戶計算機上對伺候器連接。 同樣地, 服務器TCP/IP套接字網(wǎng)絡控件庫 (Ssnetlib.dll) 一定在伺候器計算機上聽。 在這一個情節(jié)中, TCP/IP協(xié)議堆棧一定是裝置在客戶計算機和服務器計算機。

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.