Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL SERVER services get stopped Expand / Collapse
Author
Message
Posted Wednesday, January 23, 2013 2:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 3:24 AM
Points: 27, Visits: 283
Hi, Everyday we notice SQL SERVER services get stopped and we have to manually then start both services and agent.We have checked event logs but didn't get any clue.

Is there any way to find out who stop the SQL service?

Post #1410416
Posted Thursday, March 7, 2013 10:53 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 6, 2014 11:07 AM
Points: 11, Visits: 47
Did you see the last messages in sql server errorlog?

Did you have some kind of monitoring more specific for the sql server like the SQLDIAG? It could give you more clues of what was processing in SQL SERVER before the crash.


André CR
Post #1428142
Posted Sunday, May 19, 2013 11:29 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:49 AM
Points: 62, Visits: 326
You check server start time and only sys admin can start or stop server.Better way give minimum right to user.
Post #1454353
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse