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.
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.
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.
Thank you @AmeliaGu-msft
The Event ID 17148 , is the SQL Service is manually stopped from the SCM, which is of Eventtype Information
What would be eventID when SQL Server is stopped due to some ERROR.
What would be eventID when SQL Server is stopped due to some ERROR.
open Task Manager. Find the SQL Server process. Press the Delete button. Check Event Viewer. Don't do this on a server where you have databases you care for.
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

15 people are following this question.