SQL Service terminating of it's own volition?

  • ==================

    Date9/16/2009 5:04:08 PM

    LogWindows NT (Application)

    SourceMSSQLSERVER

    CategoryServer

    Event1073758972

    Message

    SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.

    ==================

    Any ideas what this is/how to fix it so it doesn't recur?

    Thanks a ton/

    Matt

  • Some process is sending a stop to the service control manager.. That can't be prevented since it happens and is normal.... Only a fairly high level user could do that.. I'm not sure by I think that this can be audited from the OS level..

    CEWII

  • More detail would better help us determine what the problem is. Could you provide a few of the messages that stand out prior to the one provided? Also is the SQL Server configured as a cluster. This message will pop-up when the cluster fails over to the second node.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • You might try looking at the System Log to see if there is a security event at the same, or near the time. I did a shutdown on my local machine and I can see the user that sent the request. You might look there..

    CEWII

  • This generally happens immediately before you server bootsup or shutdown.

    And

    if somebody manually stoping the services from Service console.

    As stated by other check the windows event logs for more details.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

Viewing 5 posts - 1 through 4 (of 4 total)

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