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
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.
