none
SQL Server 2012 Install Error 851A001A RRS feed

  • Question

  • Hi,

    I am trying to isntall SQL Server 2012 on Windows Server 2008 R2, but the Database Engine Services failed to install, and I cannot start the MSSQLSERVER Service after installation.

    Installation error:

    Error installing SQL Server Database Engine Services Instance Features
    Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
    Error code: 0x851A001A

    W3WP.EXE Crash:

    I noticed that during installation w3wp.exe has crashed:

    Application: w3wp.exe
    Framework Version: v4.0.30319
    Description: The process was terminated due to an unhandled exception.
    Exception Info: System.TypeInitializationException
    Stack:
       at System.Web.Caching.SqlCacheDependencyManager.Dispose(Int32)
       at System.Web.HttpRuntime.Dispose()
       at System.Web.HttpRuntime.ReleaseResourcesAndUnloadAppDomain(System.Object)
       at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
       at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
       at System.Threading.ThreadPoolWorkQueue.Dispatch()
       at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()

    A process serving application pool 'HTTP Pool' suffered a fatal communication error with the Windows Process Activation Service. The process id was '4544'. The data field contains the error number.

    MSSQL Service:

    When I try to start the MSSQL service, I get the following errors in the event log:

    - For target, "5B2DA06D-898A-43C8-9309-39BBBE93EBBD.package0.event_file", the parameter "filename" passed is invalid. Target parameter at index 0 is invalid
    - Event session "system_health" failed to start. Refer to previous errors in the current session to identify the cause, and correct any associated problems.
    - Script level upgrade for database 'master' failed because upgrade step 'u_tables.sql' encountered error 25641, state 0, severity 16. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.
    - Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.

    Installation Log:

    Overall summary:
      Final result:                  Failed: see details below
      Exit code (Decimal):           -2061893606
      Start time:                    2013-06-10 23:02:24
      End time:                      2013-06-11 00:06:27
      Requested action:              Install

    Setup completed with required actions for features.
    Troubleshooting information for those features:
      Next step for SQLEngine:       Use the following information to resolve the error, uninstall this feature, and then run the setup process again.


    Machine Properties:
      Machine name:                  SERVER01
      Machine processor count:       4
      OS version:                    Windows Server 2008 R2
      OS service pack:               Service Pack 1
      OS region:                     United States
      OS language:                   English (United States)
      OS architecture:               x64
      Process architecture:          64 Bit
      OS clustered:                  No

    Product features discovered:
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered

    Package properties:
      Description:                   Microsoft SQL Server 2012 Service Pack 1
      ProductName:                   SQL Server 2012
      Type:                          RTM
      Version:                       11
      Installation location:         N:\Software\Windows Server\Microsoft SQL Server 2012 SP1 (x64)\x64\setup\
      Installation edition:          Web

      Slipstream:                    True
      SP Level                       1
      Patch Level:                   11.1.3128.0

    Product Update Status:
      Success: KB 2674319, KB 2793634

    Product Updates Selected for Installation:
      Title:                         Service Pack 1
      Knowledge Based Article:       KB 2674319
      Version:                       11.1.3000.0
      Architecture:                  x64
      Language:                      1033

      Title:                         SQL Server 2012 SP1 GDR Product Update
      Knowledge Based Article:       KB 2793634
      Version:                       11.1.3128.0
      Architecture:                  x64
      Language:                      All

      Update Source:                 MU


    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      false
      AGTSVCACCOUNT:                 NT Service\SQLSERVERAGENT
      AGTSVCPASSWORD:                *****
      AGTSVCSTARTUPTYPE:             Manual
      ASBACKUPDIR:                   Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   Config
      ASDATADIR:                     Data
      ASLOGDIR:                      Log
      ASPROVIDERMSOLAP:              1
      ASSERVERMODE:                  MULTIDIMENSIONAL
      ASSVCACCOUNT:                  <empty>
      ASSVCPASSWORD:                 <empty>
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            <empty>
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Disabled
      CLTCTLRNAME:                   <empty>
      CLTRESULTDIR:                  <empty>
      CLTSTARTUPTYPE:                0
      CLTSVCACCOUNT:                 <empty>
      CLTSVCPASSWORD:                <empty>
      CLTWORKINGDIR:                 <empty>
      COMMFABRICENCRYPTION:          0
      COMMFABRICNETWORKLEVEL:        0
      COMMFABRICPORT:                0
      CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130610_224552\ConfigurationFile.ini
      CTLRSTARTUPTYPE:               0
      CTLRSVCACCOUNT:                <empty>
      CTLRSVCPASSWORD:               <empty>
      CTLRUSERS:                     <empty>
      ENABLERANU:                    false
      ENU:                           true
      ERRORREPORTING:                false
      FEATURES:                      SQLENGINE, SSMS
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 <empty>
      HELP:                          false
      IACCEPTSQLSERVERLICENSETERMS:  true
      INDICATEPROGRESS:              false
      INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
      INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
      INSTALLSQLDATADIR:             E:\MSSQL
      INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
      INSTANCEID:                    MSSQLSERVER1
      INSTANCENAME:                  MSSQLSERVER
      ISSVCACCOUNT:                  NT AUTHORITY\Network Service
      ISSVCPASSWORD:                 <empty>
      ISSVCSTARTUPTYPE:              Automatic
      MATRIXCMBRICKCOMMPORT:         0
      MATRIXCMSERVERNAME:            <empty>
      MATRIXNAME:                    <empty>
      NPENABLED:                     0
      PID:                           *****
      QUIET:                         false
      QUIETSIMPLE:                   false
      ROLE:                          <empty>
      RSINSTALLMODE:                 DefaultNativeMode
      RSSHPINSTALLMODE:              DefaultSharePointMode
      RSSVCACCOUNT:                  <empty>
      RSSVCPASSWORD:                 <empty>
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         <empty>
      SECURITYMODE:                  <empty>
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  Latin1_General_CI_AS
      SQLSVCACCOUNT:                 NT Service\MSSQLSERVER
      SQLSVCPASSWORD:                <empty>
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           ELXTECH\Administrator
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBLOGDIR:               <empty>
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SQMREPORTING:                  false
      TCPENABLED:                    1
      UIMODE:                        Normal
      UpdateEnabled:                 true
      UpdateSource:                  MU
      X86:                           false

      Configuration file:            C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130610_224552\ConfigurationFile.ini

    Detailed results:
      Feature:                       Management Tools - Basic
      Status:                        Passed

      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred during the setup process of the feature.
      Next Step:                     Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
      Component name:                SQL Server Database Engine Services Instance Features
      Component error code:          0x851A001A
      Error description:             Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026

      Feature:                       SQL Browser
      Status:                        Passed

      Feature:                       SQL Writer
      Status:                        Passed

      Feature:                       SQL Client Connectivity
      Status:                        Passed

      Feature:                       SQL Client Connectivity SDK
      Status:                        Passed

    Rules with failures:

    Global rules:

    Scenario specific rules:

    Rules report file:               C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130610_224552\SystemConfigurationCheck_Report.htm

    Tuesday, June 11, 2013 4:36 AM

Answers

  • I managed to solve the problem by doing the following steps:

    1. In the Services.msc console, change the account of the "SQL Server" service to Local System account (in the service properties). Take note of the account name before changing it, you need it at step #3.

    2. Start the service. It should be able to start at this point.

    3. Using the SQL Configuration Manager (you won't be able to do it using Services.msc), change the account back to NT Service\MSSQL$<Instance Name>.

    • Marked as answer by sixstorm1 Tuesday, June 11, 2013 7:40 AM
    Tuesday, June 11, 2013 7:40 AM

All replies

  • Check this link,

    http://blogs.msdn.com/b/sqljourney/archive/2012/03/16/sql-2008-r2-setup-fails-with-quot-wait-on-the-database-engine-recovery-handle-failed-quot.aspx


    Thanks & Regards RAJUKIRAN L Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.

    Tuesday, June 11, 2013 7:36 AM
  • I managed to solve the problem by doing the following steps:

    1. In the Services.msc console, change the account of the "SQL Server" service to Local System account (in the service properties). Take note of the account name before changing it, you need it at step #3.

    2. Start the service. It should be able to start at this point.

    3. Using the SQL Configuration Manager (you won't be able to do it using Services.msc), change the account back to NT Service\MSSQL$<Instance Name>.

    • Marked as answer by sixstorm1 Tuesday, June 11, 2013 7:40 AM
    Tuesday, June 11, 2013 7:40 AM
  • I managed to do the first two steps but no the third one.

    What's the password for that user?

    Wednesday, June 19, 2013 10:23 AM
  • You do not need to provide the password, it will fill in automatically when you click OK. But you MUST use the SQL Configuration Manager for the 3rd step, not services.msc. Services.msc will ask for the password.
    Wednesday, June 19, 2013 1:41 PM
  • 把啟動Database engine的帳號換用NT Authority\Network Service

    變更【SQL Server Database Engine】的帳戶名稱,選用<<瀏覽…>>

    按〔進階〕進入搜尋視窗,或直接輸入Network Service再按〔檢查名稱〕搜尋Network Service以使用此帳戶

    Wednesday, February 17, 2016 9:27 AM