Error Message Connecting To SQL Server Using Multiprotocol

• Microsoft Windows 98 Second Edition
• Microsoft SQL Server version 6.5 Service Pack 4 and later

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 this to be a problem in the Microsoft products 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.

Additional query words:

Keywords : kberrmsg kbnetwork kbui win98
Version : WINDOWS:; winnt:6.5 Service Pack 4 and later
Platform : WINDOWS winnt
Issue type : kbprb