Article ID: 68941 - View products that this article applies to.
This article was previously published under Q68941
When a workstation client application has problems connecting to SQL Server, the question first asked is, "How do I determine if this is a problem with my network software, or if this is a problem with SQL Server?" The following instructions explain how to test the network and local named pipes to help isolate network software problems.
Testing network named pipesThere are two utilities shipped with SQL Server designed to help test network named pipes. The MakePipe.exe and ReadPipe.exe utilities are installed during installation of both the client and server components. There are different versions of these utilities for the different operating systems on which they run: MakePipe.exe runs on Microsoft Windows NT, ReadpPipe.exe runs on Windows NT, Microsoft Windows, and MS-DOS. Be sure to use the correct version for the operating system that you are testing. (The version that runs on Windows is named Readpipe.exe. If the SQL Server tools are installed, ReadPipe.exe is located in the \Mssql\Binn directory; no icon is created for it.)
The MakePipe.exe and ReadPipe.exe utilities are not installed by SQL Server 2000 Setup. They can be found in the x:\x86\Binn directory on the SQL Server 2000 compact disc.
Used together, these utilities test the integrity of the network named pipe services. To use these utilities, perform the following steps:
If the results are different from step 3 above, the network named pipe services are not established. Clients will not be able to connect to SQL Server until named pipes are available. In addition, these utilities merely attempt to open and use a named pipe. They do not stress this named pipe connection. Thus, although these tests may succeed, the network connection may break under a heavy load.
Testing Local Named PipesOne last test is to connect to the SQL Server on the server machine using local pipes. The following will make a local ISQL connection to the SQL Server when run at the DOS command-line prompt on the database server machine:
isql /S /Ulogin /Ppassword
To make a local connection using ISQLW (SQL 6.5) or Query Analyzer (SQL 7.0), enter "(local)" or "." (without the quotation marks) in the Server Name field in the Connect To SQL Server dialog box.
Article ID: 68941 - Last Review: January 10, 2006 - Revision: 4.3
Contact us for more help