Error Message Connecting To SQL Server Using Multiprotocol (232138)


The information in this article applies to:

  • Microsoft Windows 98 Second Edition
  • Microsoft SQL Server 6.5 Service Pack 4 and later
This article was previously published under Q232138

SYMPTOMS

When you attempt to connect to a SQL version 6.5-based server and your DSN to that server is set to use multiprotocol, you may receive the following error message:
Connection failed: SQLState: '01000', SQL Server Error:0, [Microsoft][ODBC SQL Server Driver][Multi-Protocol], Connection failed:, SQL State: '08s01', SQL Server Error:0, [Microsoft][ODBC SQL Server Driver] Communication link failure

RESOLUTION

To work around this problem, connect to the SQL version 6.5-based server using the named pipes protocol from the client:
  1. Click Start, point to Settings, click Control Panel, and then double-click ODBC Data Sources (32bit).
  2. Double-click the DSN that is generating the error message, click Next, click Client Configuration, and then click Named Pipes in the Add Network Library box to select it as the network library.
  3. Click Next, and then click Finish to save the DSN.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

This problem is specific to SQL version 6.5-based servers, and this problem does not occur in SQL version 7.0-based servers.
Modification Type:MajorLast Reviewed:10/10/2003
Keywords:kberrmsg kbnetwork kbprb kbui KB232138
©2003 Microsoft Corporation. All rights reserved.