Microsoft KB Archive/232138

= Error Message Connecting To SQL Server Using Multiprotocol =

Article ID: 232138

Article Last Modified on 1/24/2007

-

APPLIES TO


 * Microsoft Windows 98 Second Edition
 * Microsoft SQL Server 6.5 Service Pack 4

-



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.

Keywords: kberrmsg kbnetwork kbprb kbui KB232138

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.