Microsoft KB Archive/265741

= BUG: SQL Server Query Analyzer Displays Incorrect Error Number When Connected to a Paused SQL Server =

Article ID: 265741

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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 &quot;Symptoms&quot; section occurs.

Keywords: kbbug kbpending KB265741

-

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

© Microsoft Corporation. All rights reserved.