Event ID for SQL Server Stopped and Event ID for SQL Agent Stopped

Question

In the Windows Event Viewer,

1)what is the Event ID for SQL Server Stopped and
2)what is the Event ID for SQL Agent Stopped

Will the EVENT-Type be Information or ERROR or Warning for SQL Server stopped.

Answer 1

Hi MSTechie-7364,

what is the Event ID for SQL Server Stopped

When SQL Serer stopped, There will be an information type Event ID 17148 (SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.) in the application log and an information type Event ID 7036 (The SQL Server (instancename) service entered the stopped state.) in the system log.

what is the Event ID for SQL Agent Stopped.

when SQL Server Agent stopped, there will be an information type Event ID 15457 (Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.) and an information type Event ID 7036 (The SQL Server Agent(instancename) service entered the stopped state.) in the system log.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Good day,

(1) Open the SQL Server Configuration Manager

(2) Open event viewer -> windows log -> application -> sort the information by date

(3) Using the SQL Server Configuration Manager Stop the server

(4) Check the events which were added in the event viewer

Next do the same for the SQL Server Agent service

Note! Stopping the SQL Server will stop related services and you will probably get a few events