BUG: Multi-Protocol Connection Fails with SQL 6.5 and Integrated Security Using 7.00.623 Netlib

• Microsoft SQL Server versions 6.5, 7.0

SYMPTOMS

If a client attempts a Multi-Protocol connection using dbLibrary or ODBC to a SQL Server 6.5 server using Microsoft Windows NT Integrated Security, the connection fails with this message:

6.5 ISQL Client:

Possible network error: Write to SQL Server Failed.
Unable to connect: SQL Server is unavailable or does not exist.

Connection failed.
SQLState 01000
SQL Server Error 0
[Microsoft][ODBC SQL Server Driver][Multi-Protocol]
Connection failed.
SQLState 08S01
SQL Server Error 0
[Microsoft][ODBC SQL Server Driver] Communication link failure

Possible network error: Write to SQL Server Failed. General Network error. Check your documentation.
NetLibrary error 1722: ConnectionOpen(RpcEpResolveBinding() )

Unable to connect: SQL Server is unavailable or does not exist. General network error. Check your documentation.
NetLibrary error 1722: ConnectionOpen(RpcEpResolveBinding() )

[Microsoft][ODBC SQL Server Driver]
Communication link failure.
[Microsoft][ODBC SQL Server Driver][Multi-Protocol]

WORKAROUND

Change the security on the SQL 6.5 Server from Microsoft Windows NT Integrated to Mixed Security.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words: MDAC Trusted authenticated

Keywords : SSrvNet_Lib kbSQLServ650bug kbbug6.50.sp5
Version : winnt:6.5,7.0
Platform : winnt
Issue type : kbbug