locked
sql server stoped automatically. RRS feed

  • Question

  • hi please helpe to resolve this.

    my sql server services are stoped automatically .

    in event viewe i am geeting 15457 event id 

    "Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install."

    event id 102

    SQLServerAgent service successfully stopped.

    i manually started sql services .

    but i want reason for this.

    pls helpme

    regards

    Ganesh

    

    Saturday, May 23, 2015 6:32 AM

Answers

  • i am getting bellow error in sql server errorlog

    Service Broker manager has shut down.
    2015-05-23 08:57:02.68 spid7s      .NET Framework runtime has been stopped.
    2015-05-23 08:57:03.23 spid7s      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.

    It did not stopped automatically someone stopped it You can see it got stop request from service control manager possible somebody restarted windows server or just sql server service

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP


    Saturday, May 23, 2015 8:28 AM
    Answerer

All replies

  • i am getting bellow error in sql server errorlog

    Service Broker manager has shut down.
    2015-05-23 08:57:02.68 spid7s      .NET Framework runtime has been stopped.
    2015-05-23 08:57:03.23 spid7s      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.
    2015-05-23 08:57:03.26 spid7s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
    2015-05-23 08:57:03.32 Server      The SQL Server Network Interface library successfully deregistered the Service Principal Name (SPN) [ MSSQLSvc/MDBSQL.URJANet.co.in ] for the SQL Server service. 
    2015-05-23 08:57:03.32 Server      The SQL Server Network Interface library successfully deregistered the Service Principal Name (SPN) [ MSSQLSvc/MDBSQL.URJANet.co.in:1433 ] for the SQL Server service. 

    Saturday, May 23, 2015 6:37 AM
  • i am getting bellow error in sql server errorlog

    Service Broker manager has shut down.
    2015-05-23 08:57:02.68 spid7s      .NET Framework runtime has been stopped.
    2015-05-23 08:57:03.23 spid7s      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.

    It did not stopped automatically someone stopped it You can see it got stop request from service control manager possible somebody restarted windows server or just sql server service

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP


    Saturday, May 23, 2015 8:28 AM
    Answerer
  • Yes as per the error logs it was stopped from some process, Please check eventvwr log also to have more clarification.


    Regards, Pradyothana DP. Please Mark This As Helpful if it helps to solve your issue. ========================================================== https://social.technet.microsoft.com/Profile/pradyothanadp http://www.dbainhouse.blogspot.in/

    Sunday, May 24, 2015 3:11 PM