none
SQL Server Service Fails to Start: Error 1067. The process terminated unexpectedly

    Question

  • Hello there!

    I installed the released SQL Server 2008 R2 on x64 (amd64) computer running Windows Server 2008 R2. This was a full install with all the setup features selected in the Setup Wizard. Setup process has finished successfully. However, after a reboot I discovered that the SQL Server (INSTANCENAME) is not running. I tried to forcibly start the service from the service properties dialog using the Services snap-in. Starting the service returned the following error:

    ---------------------------
    Services
    ---------------------------
    Windows could not start the SQL Server (KL) service on Local Computer.



    Error 1067: The process terminated unexpectedly.


    ---------------------------
    OK  
    ---------------------------

    The service is running under the Network Service account selected during the setup process.

    In the Application log is see the following error:

     

    Faulting application name: sqlservr.exe, version: 2009.100.1600.1, time stamp: 0x4bb6b40b
    Faulting module name: sqlservr.exe, version: 2009.100.1600.1, time stamp: 0x4bb6b40b
    Exception code: 0xc0000005
    Fault offset: 0x00000000000a1c61
    Faulting process id: 0x17dc
    Faulting application start time: 0x01cb0ec3a63f6646
    Faulting application path: C:\Program Files\Microsoft SQL Server\MSSQL10_50.KL\MSSQL\Binn\sqlservr.exe
    Faulting module path: C:\Program Files\Microsoft SQL Server\MSSQL10_50.KL\MSSQL\Binn\sqlservr.exe
    Report Id: e4335a09-7ab6-11df-91cf-0023544cc96e

    From the Sql Server Configuration Manager I see that the SQL Server (KL) instance has the automatic startup mode and the state is Stopped.

    I have disabled all the client protocols but TCP/IP. My firewall is turned off.

    Starting the SQL Server (KL) service from the SQL Server Configuration Manager returns this error:

    ---------------------------
    SQL Server Configuration Manager
    ---------------------------
    The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details.
    ---------------------------
    OK  
    ---------------------------

    I figured out that I DON NOT HAVE THE DATA folder under the MSSQL10_50.KL folder.

    That's all I have:

    18.06.2010  12:04    <DIR>          .
    18.06.2010  12:04    <DIR>          ..
    18.06.2010  12:04    <DIR>          Binn
    18.06.2010  12:04    <DIR>          FTData
    18.06.2010  10:45    <DIR>          Install
    03.04.2010  21:59            14 176 sql_engine_core_inst_keyfile.dll
    03.04.2010  10:59            14 176 sql_fulltext_keyfile.dll
    18.06.2010  10:45    <DIR>          Upgrade

    Seems like this wasn't a success setup despite what setup wizard reported. Or I am missing something?

    Any clues?

    Thank you in advance.

    Regards,

    Stanislav.

     

    Friday, June 18, 2010 9:46 AM

Answers

  •  Hello,

    Please create a local Windows account or a domain account with administrative privileges on that computer, change the service account for MSSQLServer with the newly created account using SQL Server Configuration Manager, and try to start MSSQLServer service again.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, June 18, 2010 3:14 PM
    Moderator

All replies

  • Hello there!

    I installed the released SQL Server 2008 R2 on x64 (amd64) computer running Windows Server 2008 R2. This was a full install with all the setup features selected in the Setup Wizard. Setup process has finished successfully. However, after a reboot I discovered that the SQL Server (INSTANCENAME) is not running. I tried to forcibly start the service from the service properties dialog using the Services snap-in. Starting the service returned the following error:

    ---------------------------
    Services
    ---------------------------
    Windows could not start the SQL Server (KL) service on Local Computer.



    Error 1067: The process terminated unexpectedly.


    ---------------------------
    OK  
    ---------------------------

    The service is running under the Network Service account selected during the setup process.

    In the Application log is see the following error:

     

    Faulting application name: sqlservr.exe, version: 2009.100.1600.1, time stamp: 0x4bb6b40b
    Faulting module name: sqlservr.exe, version: 2009.100.1600.1, time stamp: 0x4bb6b40b
    Exception code: 0xc0000005
    Fault offset: 0x00000000000a1c61
    Faulting process id: 0x17dc
    Faulting application start time: 0x01cb0ec3a63f6646
    Faulting application path: C:\Program Files\Microsoft SQL Server\MSSQL10_50.KL\MSSQL\Binn\sqlservr.exe
    Faulting module path: C:\Program Files\Microsoft SQL Server\MSSQL10_50.KL\MSSQL\Binn\sqlservr.exe
    Report Id: e4335a09-7ab6-11df-91cf-0023544cc96e

    From the Sql Server Configuration Manager I see that the SQL Server (KL) instance has the automatic startup mode and the state is Stopped.

    I have disabled all the client protocols but TCP/IP. My firewall is turned off.

    Starting the SQL Server (KL) service from the SQL Server Configuration Manager returns this error:

    ---------------------------
    SQL Server Configuration Manager
    ---------------------------
    The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details.
    ---------------------------
    OK  
    ---------------------------

    I figured out that I DON NOT HAVE THE DATA folder under the MSSQL10_50.KL folder.

    That's all I have:

    18.06.2010  12:04    <DIR>          .
    18.06.2010  12:04    <DIR>          ..
    18.06.2010  12:04    <DIR>          Binn
    18.06.2010  12:04    <DIR>          FTData
    18.06.2010  10:45    <DIR>          Install
    03.04.2010  21:59            14 176 sql_engine_core_inst_keyfile.dll
    03.04.2010  10:59            14 176 sql_fulltext_keyfile.dll
    18.06.2010  10:45    <DIR>          Upgrade

    Seems like this wasn't a success setup despite what setup wizard reported. Or I am missing something?

    Any clues?

    Thank you in advance.

    Regards,

    Stanislav.

    Please excuse my cross-posting. My first assumption was that it somehow relates to failing Reporting Services setup.

    Friday, June 18, 2010 10:16 AM
  •  Hello,

    Please create a local Windows account or a domain account with administrative privileges on that computer, change the service account for MSSQLServer with the newly created account using SQL Server Configuration Manager, and try to start MSSQLServer service again.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, June 18, 2010 3:14 PM
    Moderator
  • How did you configure the data and log file paths during the setup process?  If you specified an alternate path, the data and log files would be created in the alternate path.  The details about why the service failed to start would be located in the SQL Server Error Log file.  You can find the location of that file by opening the SQL Server Configuration Manager (Start->All Programs-> Microsoft SQL Server 2008 R2->Configuration Tools->SQL Server Configuration Manager) and then click on SQL Server Services and right click on SQL Server (<Instance Name>) and open Properties.  Click Advanced and then click the drop down on Startup Parameters.  You want to find the -e parameter value, which specifies the path to the ErrorLog:

    -eC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG

    Open that file up and post the contents back here.  If it doesn't exist, you have a failed install and need to remove it and try again.  The -d and -l parameters specify the path to the data and log file for the master database.


    Jonathan Kehayias
    http://sqlblog.com/blogs/jonathan_kehayias/
    http://www.twitter.com/SQLSarg
    http://www.sqlclr.net/
    Please click the Mark as Answer button if a post solves your problem!
    Saturday, June 19, 2010 5:55 AM
    Moderator
  • Hello, Jonathan! Thank you for a quick response and detailed answer! Thank you I configured the setup with the default settings. I do NOT have the C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG path on my file system. Seems like setup has failed despite what was returned by the wizard.

    How would you recommend unistalling SQL Server in a correct manner. I mean there a gazillion of entries in the Add and Remove applet related to SQL Server. I even have two records for Microsoft SQL Server 2008 R2 (64-bit) there. Also, I have SNAC, setup support files, and R2 Setup (english). Which item you would recommend me to start with the uninstall?

    Monday, June 21, 2010 8:25 AM
  • Hello, Alberto!

    Thank you for your help.

    Of course, I do have local administrative privileges on this computer (and do not have administrative privileges in domain or forest). It seems like setup has failed installation and did not finish all the operations correctly. At least I do not even see system MDBs and the DATA folder. So it seems like setup registered DB service but failed to create complementary files causing service to be unable to start correctly.

    How do you recommend to proceed with the uninstallation? I see multiple SQL component records in the Add or Remove applet. Which one should I start with? Microsoft SQL Server 2008 R2 (64-bit) (I have 2 records of these), SNAC, Microsoft SQL Server 2008 R2 Setup (English) or Microsoft SQL Server 2008 R2 Setup Support Files?

    Thank you.

    Regards,

    Stanislav.

    P.S.: Thanks to Malcolm for moving this thread to a correct forum. I am sorry to create it in a wrong forum.

    Monday, June 21, 2010 8:34 AM
  • Hello Stanislav,

    To uninstall SQL Server 2008, please see the instructions given on the following thread:

    http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/0998ebc9-f476-4788-998e-e051b0be1bef

    If you need further assistance, just let me know.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Monday, June 21, 2010 2:16 PM
    Moderator
  • For those of you who have arrived here after attempting to install from a mounted .iso image, try this:

    • Uninstall any features that failed during installation or whose related service couldn't start
    • Use WinRAR to extract the .iso to a local folder.  WinZip doesn't always unpack .iso images reliably.
    • Run the installer from the local folder instead of the .iso

    I had the same problem trying to install on a Windows 7 Ultimate VM, and these steps worked for me.  I use separate local accounts for each service.

     

    Cheers,

    Donny

    Tuesday, March 01, 2011 10:38 PM
  • Alberto, your response is spot on and working for me like a charm.

    I am tyring to give you a credit for this by "Vote as Helpful" but unfortunately its keep on giving me errors :)

    cheers mate.


    Khurram Jamshed - MBA, PMP, MCTS, MCITP ( Blog, Twitter, Linkedin )

    Tuesday, September 04, 2012 8:03 AM
  • Hello,

    Thank you for your feedback Khurram!   

    Have a great day!

    Hope this helps.

    Regards,
    Alberto Morillo
    SQLCoffee.com

    Friday, September 07, 2012 12:53 PM
    Moderator
  • Thanks Alberto. Your solution worked for me!
    • Proposed as answer by Njigua Monday, June 24, 2013 9:47 AM
    • Unproposed as answer by Njigua Monday, June 24, 2013 9:47 AM
    Thursday, November 15, 2012 2:16 AM
  • Hey Guys,

    I simply did a repair using the SQL CD and everything worked fine.

    Also try this if anyone else is having a problem.
    Monday, June 24, 2013 9:48 AM