locked
Could not start the MSSQLSERVER service on Local Computer Error 1067: The process terminated unexpectedly. RRS feed

  • Question

  • Event Type: Error
    Event Source: Service Control Manager
    Event Category: None
    Event ID: 7034
    Date:  2/19/2012
    Time:  11:24:05 PM
    User:  N/A
    Computer: TCCNYBB1
    Description:
    The MSSQLSERVER service terminated unexpectedly.  It has done this 22 time(s).

    ---------------------------
    Services
    ---------------------------
    Could not start the MSSQLSERVER service on Local Computer.

    Error 1067: The process terminated unexpectedly.

    This error starting occurring after unexpected reboot of server, I have just similar issue on MS Forum nothing helped so far.

    SQL Server version 2000

    Monday, February 20, 2012 5:04 AM

Answers

  • Hi Pankaj,

    View the SQL Server error log by using SQL Server Enterprise Manager or any text editor. By default, the error log is located at Program Files\Microsoft SQL Server\Mssql\Log\Errorlog.

    Open the file and post the contents back here.  If it doesn't exist, you may have a failed install and need to remove it and try again.

    Thanks,
    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

    • Marked as answer by Maggie Luo Tuesday, March 6, 2012 7:40 AM
    Tuesday, February 21, 2012 9:15 AM

All replies

  • Hello Pankaj,

       Could you please share the error logs of the time when the service fails?


    Kind regards| Harsh Chawla | Personal Blog:- SQL-blogs
    |Team Blog:- Team Blog

    Monday, February 20, 2012 5:26 AM
  • Error: 17883, Severity: 1, State: 0

    2012-02-19 16:48:02.22 server    The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x00C56420.
    2012-02-19 18:47:38.16 spid13    This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected. 10:44

    Error log not modified after unexpected reboot.

    All sql server msde  instances are in stopped mode and while tried to start it prompts the same error.
    While execute the checkdisk on drive c it is prompts the following error:
    “Windows found problems with the file system.

    Run CHKDSK with the /F (fix) option to correct these.”

    Monday, February 20, 2012 5:34 AM
  • The error which you are seeing is non-yielding scheduler (17883). Could you please paste/share the entire SQL server errorlog file?

    Kind regards| Harsh Chawla | Personal Blog:- SQL-blogs
    |Team Blog:- Team Blog


    Monday, February 20, 2012 5:46 AM
  • Hi Pankaj,

    View the SQL Server error log by using SQL Server Enterprise Manager or any text editor. By default, the error log is located at Program Files\Microsoft SQL Server\Mssql\Log\Errorlog.

    Open the file and post the contents back here.  If it doesn't exist, you may have a failed install and need to remove it and try again.

    Thanks,
    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

    • Marked as answer by Maggie Luo Tuesday, March 6, 2012 7:40 AM
    Tuesday, February 21, 2012 9:15 AM