Exit code (Decimal): -2061893606Error description: Error en la espera del controlador de recuperación del Motor de base de de datos. Revise el registro de errores de SQL Server para conocer posibles causas.

Question

Exit code (Decimal): -2061893606Error description: Error en la espera del controlador de recuperación del Motor de base de de datos. Revise el registro de errores de SQL Server para conocer posibles causas.

Lucas Laurito 25

Overall summary:
  Final result:                  Error: vea los detalles a continuación
  Exit code (Decimal):           -2061893606
  Start time:                    2023-11-05 12:17:59
  End time:                      2023-11-05 12:20:13
  Requested action:              Install

Setup completed with required actions for features.
Troubleshooting information for those features:
  Next step for SQLEngine:       Use la siguiente información para resolver el error, desinstale esta característica y ejecute de nuevo el proceso de instalación.


Machine Properties:
  Machine name:                  LUCA5
  Machine processor count:       12
  OS version:                    Microsoft Windows 11 Home Single Language (10.0.22621)
  OS service pack:               
  OS region:                     Argentina
  OS language:                   español (México)
  OS architecture:               x64
  Process architecture:          64 bits
  OS clustered:                  No

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

Package properties:
  Description:                   Microsoft SQL Server 2019 
  ProductName:                   SQL Server 2019
  Type:                          RTM
  Version:                       15
  SPLevel:                       0
  Installation location:         C:\SQL2019\Express_ENU\x64\setup\
  Installation edition:          Express

Product Update Status:
  El usuario seleccionó que no se incluyan actualizaciones de productos.

Configuración de entrada de usuario:
  ACTION:                        Install
  ADDCURRENTUSERASSQLADMIN:      true
  AGTSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
  AGTSVCPASSWORD:                *****
  AGTSVCSTARTUPTYPE:             Disabled
  ASBACKUPDIR:                   Backup
  ASCOLLATION:                   Latin1_General_CI_AS
  ASCONFIGDIR:                   Config
  ASDATADIR:                     Data
  ASLOGDIR:                      Log
  ASPROVIDERMSOLAP:              1
  ASSERVERMODE:                  TABULAR
  ASSVCACCOUNT:                  <vacío>
  ASSVCPASSWORD:                 <vacío>
  ASSVCSTARTUPTYPE:              Automatic
  ASSYSADMINACCOUNTS:            <vacío>
  ASTELSVCACCT:                  <vacío>
  ASTELSVCPASSWORD:              <vacío>
  ASTELSVCSTARTUPTYPE:           0
  ASTEMPDIR:                     Temp
  BROWSERSVCSTARTUPTYPE:         Disabled
  CLTCTLRNAME:                   <vacío>
  CLTRESULTDIR:                  <vacío>
  CLTSTARTUPTYPE:                0
  CLTSVCACCOUNT:                 <vacío>
  CLTSVCPASSWORD:                <vacío>
  CLTWORKINGDIR:                 <vacío>
  COMMFABRICENCRYPTION:          0
  COMMFABRICNETWORKLEVEL:        0
  COMMFABRICPORT:                0
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20231105_121759\ConfigurationFile.ini
  CTLRSTARTUPTYPE:               0
  CTLRSVCACCOUNT:                <vacío>
  CTLRSVCPASSWORD:               <vacío>
  CTLRUSERS:                     <vacío>
  ENABLERANU:                    true
  ENU:                           true
  EXTSVCACCOUNT:                 <vacío>
  EXTSVCPASSWORD:                <vacío>
  FEATURES:                      SQLENGINE
  FILESTREAMLEVEL:               0
  FILESTREAMSHARENAME:           <vacío>
  FTSVCACCOUNT:                  <vacío>
  FTSVCPASSWORD:                 <vacío>
  HELP:                          false
  IACCEPTPYTHONLICENSETERMS:     false
  IACCEPTROPENLICENSETERMS:      false
  IACCEPTSQLSERVERLICENSETERMS:  true
  IACKNOWLEDGEENTCALLIMITS:      false
  INDICATEPROGRESS:              true
  INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
  INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
  INSTALLSQLDATADIR:             <vacío>
  INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server
  INSTANCEID:                    SQLEXPRESS
  INSTANCENAME:                  SQLEXPRESS
  ISMASTERSVCACCOUNT:            NT AUTHORITY\Network Service
  ISMASTERSVCPASSWORD:           <vacío>
  ISMASTERSVCPORT:               8391
  ISMASTERSVCSSLCERTCN:          <vacío>
  ISMASTERSVCSTARTUPTYPE:        Automatic
  ISMASTERSVCTHUMBPRINT:         <vacío>
  ISSVCACCOUNT:                  NT AUTHORITY\Network Service
  ISSVCPASSWORD:                 <vacío>
  ISSVCSTARTUPTYPE:              Automatic
  ISTELSVCACCT:                  <vacío>
  ISTELSVCPASSWORD:              <vacío>
  ISTELSVCSTARTUPTYPE:           0
  ISWORKERSVCACCOUNT:            NT AUTHORITY\Network Service
  ISWORKERSVCCERT:               <vacío>
  ISWORKERSVCMASTER:             <vacío>
  ISWORKERSVCPASSWORD:           <vacío>
  ISWORKERSVCSTARTUPTYPE:        Automatic
  MATRIXCMBRICKCOMMPORT:         0
  MATRIXCMSERVERNAME:            <vacío>
  MATRIXNAME:                    <vacío>
  MRCACHEDIRECTORY:              
  NPENABLED:                     0
  PBDMSSVCACCOUNT:               <vacío>
  PBDMSSVCPASSWORD:              <vacío>
  PBDMSSVCSTARTUPTYPE:           0
  PBENGSVCACCOUNT:               <vacío>
  PBENGSVCPASSWORD:              <vacío>
  PBENGSVCSTARTUPTYPE:           0
  PBPORTRANGE:                   <vacío>
  PBSCALEOUT:                    false
  PID:                           *****
  QUIET:                         true
  QUIETSIMPLE:                   false
  ROLE:                          AllFeatures_WithDefaults
  RSINSTALLMODE:                 DefaultNativeMode
  RSSVCACCOUNT:                  <vacío>
  RSSVCPASSWORD:                 <vacío>
  RSSVCSTARTUPTYPE:              Automatic
  SAPWD:                         <vacío>
  SECURITYMODE:                  <vacío>
  SQLBACKUPDIR:                  <vacío>
  SQLCOLLATION:                  Modern_Spanish_CI_AS
  SQLJAVADIR:                    <vacío>
  SQLMAXDOP:                     0
  SQLMAXMEMORY:                  2147483647
  SQLMINMEMORY:                  0
  SQLSVCACCOUNT:                 NT Service\MSSQL$SQLEXPRESS
  SQLSVCINSTANTFILEINIT:         true
  SQLSVCPASSWORD:                <vacío>
  SQLSVCSTARTUPTYPE:             Automatic
  SQLSYSADMINACCOUNTS:           LUCA5\LUCAS
  SQLTELSVCACCT:                 NT Service\SQLTELEMETRY$SQLEXPRESS
  SQLTELSVCPASSWORD:             <vacío>
  SQLTELSVCSTARTUPTYPE:          Automatic
  SQLTEMPDBDIR:                  <vacío>
  SQLTEMPDBFILECOUNT:            1
  SQLTEMPDBFILEGROWTH:           64
  SQLTEMPDBFILESIZE:             8
  SQLTEMPDBLOGDIR:               <vacío>
  SQLTEMPDBLOGFILEGROWTH:        64
  SQLTEMPDBLOGFILESIZE:          8
  SQLUSERDBDIR:                  <vacío>
  SQLUSERDBLOGDIR:               <vacío>
  SUPPRESSPAIDEDITIONNOTICE:     false
  SUPPRESSPRIVACYSTATEMENTNOTICE: false
  TCPENABLED:                    0
  UIMODE:                        AutoAdvance
  UpdateEnabled:                 false
  UpdateSource:                  MU
  USEMICROSOFTUPDATE:            false
  USESQLRECOMMENDEDMEMORYLIMITS: false
  X86:                           false

  Configuration file:            C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20231105_121759\ConfigurationFile.ini

Detailed results:
  Feature:                       Servicios de Motor de base de datos
  Status:                        Error
  Reason for failure:            Error durante el proceso de instalación de la característica.
  Next Step:                     Use la siguiente información para resolver el error, desinstale esta característica y ejecute de nuevo el proceso de instalación.
  Component name:                Características de instancia de los Servicios de motor de base de datos de SQL Server
  Component error code:          0x851A001A
  Error description:             Error en la espera del controlador de recuperación del Motor de base de datos. Revise el registro de errores de SQL Server para conocer posibles causas.
  Error help link:               https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026

Rules with failures or warnings:

Global rules:
Advertencia IsFirewallEnabled                El Firewall de Windows está habilitado. Compruebe que están abiertos los puertos correspondientes para habilitar el acceso remoto. Consulte la documentación sobre reglas en https://go.microsoft.com/fwlink/?linkid=2094702 para obtener información sobre los puertos que se deben abrir para cada característica.

Rules report file:               C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20231105_121759\SystemConfigurationCheck_Report.htm

LiHongMSFT-4306 31,566 Reputation points

2023-11-06T02:40:00.6433333+00:00

Hi @Lucas Laurito

As Erland answered, we need more details information.

Please post the error logs. The location by default is: C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log

There is a summary.txt file and many subfolders created every time the Installation wizard is started. In those subfolders, we can find a Detail.txt file.

View and Read SQL Server Setup Log Files - SQL Server | Microsoft Learn
Nestor HD 0 Reputation points

2024-04-16T18:29:05.1666667+00:00

Tengo el mismo problema, aun no encuentro la solucion, me ayudan, por favor.

Accepted answer

0 additional answers

Your answer

LiHongMSFT-4306 31,566 Reputation points

2023-11-06T02:40:00.6433333+00:00

Hi @Lucas Laurito

As Erland answered, we need more details information.

Please post the error logs. The location by default is: C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log

There is a summary.txt file and many subfolders created every time the Installation wizard is started. In those subfolders, we can find a Detail.txt file.

View and Read SQL Server Setup Log Files - SQL Server | Microsoft Learn
Nestor HD 0 Reputation points

2024-04-16T18:29:05.1666667+00:00

Tengo el mismo problema, aun no encuentro la solucion, me ayudan, por favor.

Answer 1

Erland Sommarskog 121.4K MVP Volunteer Moderator

The message Wait on the Database Engine recovery handle failed is a generic error that means that SQL Server did not start when Setup wanted to run configuration steps. To understand why it did not start, you need to look in the SQL Server errorlog, which you find in C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\LOG\ERRORLOG.

If you see a message about 256 misaligned reads, you are running into a known issue where Windows 11 for some disk drives reports a sector size that SQL Server does not cope with. Microsoft has published an article with workarounds for the problem.

If you don't see the message about misaligned reads, feel free to upload the errorlog here, so we can look at it. You will need to rename to ERRORLOG.txt for the forum software to accept it.

Lucas Laurito 25 Reputation points

2023-11-06T20:27:34.0433333+00:00

ERRORLOG.txt
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-11-06T21:15:29.15+00:00

There is this message:

There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\master.mdf.

This is exactly what I said in my post. Read this article with workarounds for how to deal with this situation.
Lucas Laurito 25 Reputation points

2023-11-07T01:17:30.0966667+00:00

Thank you!
Nestor HD 0 Reputation points

2024-04-16T18:31:31.38+00:00

Lucas, como solucionaste tu problema?

Share via

Exit code (Decimal): -2061893606Error description: Error en la espera del controlador de recuperación del Motor de base de de datos. Revise el registro de errores de SQL Server para conocer posibles causas.

0 additional answers

Your answer