BUG: SQL Server Query Analyzer Displays Incorrect Error Number When Connected to a Paused SQL Server (265741)



The information in this article applies to:

  • Microsoft SQL Server 7.0

This article was previously published under Q265741
BUG #: 58064 (SQLBUG_70)

SYMPTOMS

When you connect from a client tool like Microsoft SQL Server Query Analyzer, when SQL Server is paused, the following error message occurs:
Unable to connect to server xyz
Server:Msg: - 1073724682, Level 16, state 1
[Microsoft][ODBC SQL server Driver][SQL Server]SQL Server has been paused, no new connections will be allowed.
The error message number is incorrect. The correct error number should be:
Unable to connect to server xyz
Server:Msg: - 17142, Level 16, state 1
[Microsoft][ODBC SQL server Driver][SQL Server]SQL Server has been paused, no new connections will be allowed.

STATUS

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

MORE INFORMATION

To reproduce the error message, follow these steps:
  1. Pause SQL Server from the Microsoft SQL Server Service Manager, Microsoft SQL Server Enterprise Manager or the Mssqlserver service from the Services applet in Control Panel.
  2. Open Microsoft SQL Server Query Analyzer and connect to the paused server.
  3. The error message described in the "Symptoms" section occurs.

Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug kbDSupport KB265741