SQL SERVER services get stopped

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » SQL SERVER services get stopped

SQL SERVER services get stopped

Rate Topic

Display Mode

Topic Options

Author

Message

Alone

Posted Wednesday, January 23, 2013 2:17 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 8:10 AM
Points: 21, Visits: 200

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

andrecesarr

Posted Thursday, March 07, 2013 10:53 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 15, 2013 6:11 PM
Points: 9, Visits: 40

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

dineshvishe

Posted 2 days ago @ 11:29 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 12:26 AM
Points: 40, Visits: 213

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 »

Permissions