SQL SERVER services get stopped

  • 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?

  • 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
  • You check server start time and only sys admin can start or stop server.Better way give minimum right to user.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply