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

ID: Q226109

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 54707 (SQLBUG_70)

SYMPTOMS

If SQL Server is run 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 version 7.0.

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

Additional query words: sqlagent ent man entman SEM SSEM


Keywords          : kbbug7.00 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: June 2, 1999