none
SQL Express 2008 R2 installation problem (-2061893608) RRS feed

  • Question

  • I am attempting to install SQL Express 2008R2 to use on a local computer with a software (MaxSea). The installation is run from an Admin account on a Windows XP SP3 computer. I have an error toward the end fo the installation (error "Wait on the Database Engine recovery handle failed -2061893608"). If i ignore the error and continue the installation, the service is correctly listed but will not start. I tried to un-install SQL server (from Add/Remove then "Program Files" then Registry) restart the computer and re-install multiple time without success....

    At this point, i don't know what to do. I would greatly appreciate if somebody could help me.

    ______________________________________

    Overall summary:
      Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
      Exit code (Decimal):           -2061893608
      Exit facility code:            1306
      Exit error code:               24
      Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
      Start time:                    2011-07-23 05:32:55
      End time:                      2011-07-23 05:42:51
      Requested action:              Install
      Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110723_053002\Detail.txt
      Exception help link:           http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.50.1600.1%26EvtType%3d0xE53883A0%400xBE03358B%401306%4024

    Machine Properties:
      Machine name:                  KARINS
      Machine processor count:       2
      OS version:                    Windows XP
      OS service pack:               Service Pack 3
      OS region:                     United States
      OS language:                   English (United States)
      OS architecture:               x86
      Process architecture:          32 Bit
      OS clustered:                  No

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

    Package properties:
      Description:                   SQL Server Database Services 2008 R2
      ProductName:                   SQL Server 2008 R2
      Type:                          RTM
      Version:                       10
      SPLevel:                       0
      Installation location:         c:\2107110b3354d80348a4\x86\setup\
      Installation edition:          EXPRESS

    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      True
      AGTSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
      AGTSVCPASSWORD:                *****
      AGTSVCSTARTUPTYPE:             Disabled
      ASBACKUPDIR:                   Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   Config
      ASDATADIR:                     Data
      ASDOMAINGROUP:                 <empty>
      ASLOGDIR:                      Log
      ASPROVIDERMSOLAP:              1
      ASSVCACCOUNT:                  <empty>
      ASSVCPASSWORD:                 *****
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            <empty>
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Disabled
      CONFIGURATIONFILE:            
      CUSOURCE:                     
      ENABLERANU:                    True
      ENU:                           True
      ERRORREPORTING:                False
      FARMACCOUNT:                   <empty>
      FARMADMINPORT:                 0
      FARMPASSWORD:                  *****
      FEATURES:                      SQLENGINE
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 *****
      HELP:                          False
      IACCEPTSQLSERVERLICENSETERMS:  False
      INDICATEPROGRESS:              False
      INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
      INSTALLSHAREDWOWDIR:           C:\Program Files\Microsoft SQL Server\
      INSTALLSQLDATADIR:             <empty>
      INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
      INSTANCEID:                    MAXSEASQLEXPRESS
      INSTANCENAME:                  MAXSEASQLEXPRESS
      ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
      ISSVCPASSWORD:                 *****
      ISSVCSTARTUPTYPE:              Automatic
      NPENABLED:                     0
      PASSPHRASE:                    *****
      PCUSOURCE:                    
      PID:                           *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      ROLE:                          AllFeatures_WithDefaults
      RSINSTALLMODE:                 FilesOnlyMode
      RSSVCACCOUNT:                  <empty>
      RSSVCPASSWORD:                 *****
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         *****
      SECURITYMODE:                  SQL
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
      SQLSVCPASSWORD:                *****
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           BUILTIN\ADMINISTRATORS,KARINS\Karin
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBLOGDIR:               <empty>
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SQMREPORTING:                  True
      TCPENABLED:                    0
      UIMODE:                        AutoAdvance
      X86:                           False

    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Failed: see details below
      Configuration error code:      0xBE03358B@1306@24
      Configuration error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
      Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110723_053002\Detail.txt

    _________________________________

    Extract of Detailed Log

    2011-07-23 05:41:31 SQLEngine: : Checking Engine checkpoint 'StartEngineService'
    2011-07-23 05:41:31 SQLEngine: --SqlServerServiceSCM: Starting SQL via SCM (-mSqlSetup -f -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T4010 -T3659 -T3610 -dc:\Program Files\Microsoft SQL Server\MSSQL10_50.MAXSEASQLEXPRESS\MSSQL\Template Data\master.mdf -lc:\Program Files\Microsoft SQL Server\MSSQL10_50.MAXSEASQLEXPRESS\MSSQL\Template Data\mastlog.ldf)...
    2011-07-23 05:41:31 Slp: Sco: Attempting to start service MSSQL$MAXSEASQLEXPRESS
    2011-07-23 05:41:31 Slp: Sco: Attempting to open SC Manager
    2011-07-23 05:41:31 Slp: Sco: Attempting to open service handle for service MSSQL$MAXSEASQLEXPRESS
    2011-07-23 05:41:36 Slp: Sco: Service MSSQL$MAXSEASQLEXPRESS started
    2011-07-23 05:41:36 Slp: Sco: Attempting to close service handle for service MSSQL$MAXSEASQLEXPRESS
    2011-07-23 05:41:36 Slp: Sco: Attempting to close SC Manager
    2011-07-23 05:41:36 Slp: Sco: Attempting to get service process id for service MSSQL$MAXSEASQLEXPRESS
    2011-07-23 05:41:36 Slp: Sco: Attempting to open SC Manager
    2011-07-23 05:41:36 Slp: Sco: Attempting to open service handle for service MSSQL$MAXSEASQLEXPRESS
    2011-07-23 05:41:36 Slp: Invoking QueryServiceStatusEx Win32 API
    2011-07-23 05:41:36 Slp: Sco: Attempting to close service handle for service MSSQL$MAXSEASQLEXPRESS
    2011-07-23 05:41:36 Slp: Sco: Attempting to close SC Manager
    2011-07-23 05:41:36 Slp: Sco: Returning service process id 5384
    2011-07-23 05:41:36 SQLEngine: : Checking Engine checkpoint 'GetSqlServerProcessHandle'
    2011-07-23 05:41:36 SQLEngine: --SqlServerServiceSCM: Waiting for nt event 'Global\sqlserverRecComplete$MAXSEASQLEXPRESS' to be created
    2011-07-23 05:41:37 SQLEngine: --SqlServerServiceSCM: Waiting for nt event 'Global\sqlserverRecComplete$MAXSEASQLEXPRESS' or sql process handle to be signaled
    2011-07-23 05:41:37 SQLEngine: : Checking Engine checkpoint 'WaitSqlServerStartEvents'
    2011-07-23 05:41:46 SQLEngine: --SqlServerServiceSCM: SQL Server process has died while waiting for SQL Server to start. Process id: 5384
    2011-07-23 05:41:46 SQLEngine: Copying 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MAXSEASQLEXPRESS\MSSQL\Log\ERRORLOG' to 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110723_053002\SQLServer_ERRORLOG_2011-07-23T05.41.46.txt' ...
    2011-07-23 05:41:46 Slp: Sco: Attempting to set file full path to 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MAXSEASQLEXPRESS\MSSQL\Log\ERRORLOG'
    2011-07-23 05:41:46 Slp: Sco: Attempting to normalize directory path 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MAXSEASQLEXPRESS\MSSQL\Log\ERRORLOG'
    2011-07-23 05:41:46 Slp: Sco: Attempting to check if file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MAXSEASQLEXPRESS\MSSQL\Log\ERRORLOG' exists
    2011-07-23 05:41:46 Slp: Sco: Attempting to copy file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MAXSEASQLEXPRESS\MSSQL\Log\ERRORLOG' to file 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110723_053002\SQLServer_ERRORLOG_2011-07-23T05.41.46.txt'
    2011-07-23 05:41:46 Slp: Sco: Attempting to check if file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MAXSEASQLEXPRESS\MSSQL\Log\ERRORLOG' exists
    2011-07-23 05:41:46 Slp: Sco: Attempting to normalize directory path 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110723_053002\SQLServer_ERRORLOG_2011-07-23T05.41.46.txt'
    2011-07-23 05:41:46 Slp: Sco: Attempting to set file full path to 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110723_053002\SQLServer_ERRORLOG_2011-07-23T05.41.46.txt'
    2011-07-23 05:41:46 Slp: Sco: Attempting to normalize directory path 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110723_053002\SQLServer_ERRORLOG_2011-07-23T05.41.46.txt'
    2011-07-23 05:41:46 Slp: Sco: Attempting to check if directory path 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MAXSEASQLEXPRESS\MSSQL\Log\ERRORLOG' is equal to path 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110723_053002\SQLServer_ERRORLOG_2011-07-23T05.41.46.txt'
    2011-07-23 05:41:46 Slp: Sco: Attempting to check if directory path 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MAXSEASQLEXPRESS\MSSQL\Log\ERRORLOG' is equal to path 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110723_053002\SQLServer_ERRORLOG_2011-07-23T05.41.46.txt'
    2011-07-23 05:41:46 Slp: Sco: Attempting to normalize directory path 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MAXSEASQLEXPRESS\MSSQL\Log\ERRORLOG'
    2011-07-23 05:41:46 Slp: Sco: Attempting to normalize directory path 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110723_053002\SQLServer_ERRORLOG_2011-07-23T05.41.46.txt'
    2011-07-23 05:41:46 Slp: Sco: Attempting to get security descriptor for file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MAXSEASQLEXPRESS\MSSQL\Log\ERRORLOG'
    2011-07-23 05:41:46 Slp: Sco: Attempting to check if file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MAXSEASQLEXPRESS\MSSQL\Log\ERRORLOG' exists
    2011-07-23 05:41:46 Slp: Sco: Returning security descriptor O:NSG:NSD:AI(A;ID;FA;;;NS)(A;ID;FA;;;SY)(A;ID;FA;;;BA)(A;ID;FA;;;S-1-5-21-162909976-3525991464-76603244-1037)(A;ID;0x1201ff;;;S-1-5-21-162909976-3525991464-76603244-1038)
    2011-07-23 05:41:46 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.
    2011-07-23 05:41:46 Slp: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
    2011-07-23 05:41:46 Slp: The configuration failure category of current exception is ConfigurationFailure
    2011-07-23 05:41:46 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.
    2011-07-23 05:41:46 Slp: Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineConfigException: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
    2011-07-23 05:41:46 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceBase.WaitSqlServerStart(Process processSql)
    2011-07-23 05:41:46 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StartSqlServer(String[] parameters)
    2011-07-23 05:41:46 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerStartup.StartSQLServerForInstall(String sqlCollation, String masterFullPath, Boolean isConfiguringTemplateDBs, Boolean isSlipstreamRunning)
    2011-07-23 05:41:46 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.ConfigSQLServerSystemDatabases(EffectiveProperties properties, Boolean isConfiguringTemplateDBs, Boolean useInstallInputs)
    2011-07-23 05:41:46 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.DoCommonDBStartConfig(ConfigActionTiming timing)
    2011-07-23 05:41:46 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)
    2011-07-23 05:41:46 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.PrivateConfigurationBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)
    2011-07-23 05:41:46 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SqlFeatureConfigBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)
    2011-07-23 05:41:46 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
    2011-07-23 05:41:46 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
    2011-07-23 05:41:46 Slp: Exception: Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineConfigException.
    2011-07-23 05:41:46 Slp: Source: Microsoft.SqlServer.Configuration.SqlServer_ConfigExtension.
    2011-07-23 05:41:46 Slp: Message: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes..
    2011-07-23 05:41:47 Slp: Watson Bucket 1

    2011-07-23 05:43:03 Slp: ----------------------------------------------------------------------
    2011-07-23 05:43:03 Slp:
    2011-07-23 05:43:03 Slp: Error result: -2061893608
    2011-07-23 05:43:03 Slp: Result facility code: 1306
    2011-07-23 05:43:03 Slp: Result error code: 24
    2011-07-23 05:43:03 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2011-07-23 05:43:03 Slp: Sco: Attempting to open registry subkey
    2011-07-23 05:43:03 Slp: Sco: Attempting to open registry subkey Software\Microsoft\PCHealth\ErrorReporting\DW\Installed
    2011-07-23 05:43:03 Slp: Sco: Attempting to get registry value DW0200
    2011-07-23 05:43:16 Slp: Submitted 1 of 1 failures to the Watson data repository
    2011-07-23 05:43:16 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2011-07-23 05:43:16 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\100
    2011-07-23 05:43:16 Slp: Sco: Attempting to get registry value CustomerFeedback

    Thanks!

     

    Friday, July 22, 2011 10:54 PM

All replies

  • It appears that the SQL Server Service is unable to start.  Try using a different account than NT AUTHORITY\NETWORK SERVICE

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    MC ID: Microsoft Transcript

    Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    Monday, July 25, 2011 2:51 AM
  • Hi Iker_Pryszo,

    Could you please refer to this thread addressing this type of issue: Thread: SQL Server 2008 express Install Fails?

    Hope this helps.


    Best Regards,
    Stephanie Lv

    Monday, July 25, 2011 9:36 AM
  • It appears that the SQL Server Service is unable to start.  Try using a different account than NT AUTHORITY\NETWORK SERVICE

    Dear Jeff,

    In the Service Properties (under the "Log On" tab), I already tried to log on as the "Local System Account" (with the same result). Is that what you are reffering to?

    Monday, July 25, 2011 4:05 PM
  • Sorry to bump this old thread but this is the top result on Google for this error and this isn't the first time I've run into this.

    I encountered this issue because TLS 1.0 was disabled on the machine. TLS 1.0 needs to be enabled on first SQL 2008 R2 start. It can be disabled after that.
    Friday, January 17, 2020 7:21 PM