FIX: SQLServerAgent May Shut Down If SQL Server Is Started from the Console

Article translations Article translations
Article ID: 226109 - View products that this article applies to.
This article was previously published under Q226109
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 54707 (SQLBUG_70)
Expand all | Collapse all

SYMPTOMS

If you run SQL Server from the console, the SQL Server Agent may shut itself down. This problem can occur when trying to connect by means of SQL Server Enterprise Manager, but may also occur when performing certain tasks when configuring replication.

CAUSE

It can appear to the SQL Server Agent that SQL Server has stopped, when in fact the server is still running.

WORKAROUND

To work around this problem, start SQL Server as a service.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.

MORE INFORMATION

When SQL Server Agent shuts down in this scenario, the following message is dumped to the console (and to the SQL Server Agent log, if enabled) when SQL Server Agent is run from the console:
SQLServerAgent initiating shutdown following MSSQLServer shutdown

Properties

Article ID: 226109 - Last Review: October 20, 2013 - Revision: 2.0
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbfix KB226109

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com