question

srivivek avatar image
srivivek asked

sql server is running but showing stopped in configuration manager

hi, Sql server got restarted when checked in the log i am not able to find any info about why/who restarted it Is there a way to find out? and when i checked the congiguration manager the all the services are showing stopped except sql browser but i am able to access sql and sql agent,why is it showing like that? and when checked SQl server services are in manual mode
configurationmanagersql_restart
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Shawn_Melton avatar image
Shawn_Melton answered
I don't see why you would want SQL Server in manual mode, but you probably have a reason. You might also check the services applet through Administrator Tools in Windows to see what the status of your SQL services show there. Sometimes SSCM can get a little confused if someone messed with the WMI settings on your server. Regarding still being able to access it if they show stopped in SSCM, check the services applet. If it shows stopped as well though, are you sure you are connecting to that instance? I have had issues where I connect to more than one instance of SQL Server in SSMS and think I'm on one to find out I connected to a different instance/server with similar names. Windows Event log should show if a user started/stopped the service either in Application or System event log. You might also browse the Security log for the same timeframe and you could get an idea of who was logged onto the server. You can also check the last SQL Server ERRORLOG prior to it restarting and it might have some errors showing if it had issues. Otherwise checking the Windows event log is your best option.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.