Error en la espera del controlador de recuperación del Motor de base de datos. - Exit Code Decimal -2061893606, Código de error: 0x84B40002

Question

Error en la espera del controlador de recuperación del Motor de base de datos. - Exit Code Decimal -2061893606, Código de error: 0x84B40002

David Poma 1

Este es el archivo de registro:

Overall summary:
Final result: Error: vea los detalles a continuación
Exit code (Decimal): -2068578302
Start time: 2022-01-22 16:12:21
End time: 2022-01-22 16:13:29
Requested action: Repair

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 e intente de nuevo el proceso de instalación.
Next step for Replication: Use la siguiente información para resolver el error e intente de nuevo el proceso de instalación.

Machine Properties:
Machine name: DESKTOP-INGAMS9
Machine processor count: 16
OS version: Microsoft Windows 11 Enterprise (10.0.22000)
OS service pack:
OS region: España
OS language: español (España, alfabetización internacional)
OS architecture: x64
Process architecture: 64 bits
OS clustered: No

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered Configured
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Servicios de Motor de base de datos 1033 Developer Edition 15.0.2000.5 No Sí
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Servicios de Motor de base de datos 3082 Developer Edition 15.0.2000.5 No Sí
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Replicación de SQL Server 1033 Developer Edition 15.0.2000.5 No Sí
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Replicación de SQL Server 3082 Developer Edition 15.0.2000.5 No Sí

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

Configuración de entrada de usuario:
ACTION: Repair
AGTDOMAINGROUP: <vacío>
AGTSVCACCOUNT: <vacío>
AGTSVCPASSWORD: <vacío>
AGTSVCSTARTUPTYPE: Manual
ASCONFIGDIR: Config
ASSVCACCOUNT: <vacío>
ASSVCPASSWORD: <vacío>
ASTELSVCACCT: <vacío>
ASTELSVCPASSWORD: <vacío>
ASTELSVCSTARTUPTYPE: 0
CLTSTARTUPTYPE: 0
CLTSVCACCOUNT: <vacío>
CLTSVCPASSWORD: <vacío>
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220122_161221\ConfigurationFile.ini
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT: <vacío>
CTLRSVCPASSWORD: <vacío>
ENU: false
EXTSVCACCOUNT: <vacío>
EXTSVCPASSWORD: <vacío>
FAILOVERCLUSTERGROUP: <vacío>
FAILOVERCLUSTERNETWORKNAME: <vacío>
FTSVCACCOUNT: <vacío>
FTSVCPASSWORD: <vacío>
HELP: false
IACCEPTPYTHONLICENSETERMS: false
IACCEPTROPENLICENSETERMS: false
IACKNOWLEDGEENTCALLIMITS: false
INDICATEPROGRESS: false
INSTANCENAME: MSSQLSERVER
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
MRCACHEDIRECTORY:
QUIET: false
QUIETSIMPLE: false
SQLSVCACCOUNT: NT Service\MSSQLSERVER
SQLSVCPASSWORD: <vacío>
SQLTELSVCACCT: NT Service\SQLTELEMETRY
SQLTELSVCPASSWORD: <vacío>
SQLTELSVCSTARTUPTYPE: Automatic
SUPPRESSPAIDEDITIONNOTICE: false
SUPPRESSPRIVACYSTATEMENTNOTICE: false
UIMODE: Normal
X86: false

Configuration file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220122_161221\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 e intente 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: 0x84B40002
Error description: La característica 'SQL_Engine_Core_Inst' de SQL Server no tiene un estado de reparación admitido, ya que nunca se configuró correctamente. Solo las características de instalaciones correctas se pueden reparar. Para continuar, quite la característica especificada.
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=0x2841E06E%401204%402&EvtType=0x2841E06E%401204%402

Feature: Replicación de SQL Server
Status: Error
Reason for failure: Error en el proceso de instalación de la característica debido a un error en una dependencia de la misma.
Next Step: Use la siguiente información para resolver el error e intente 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: 0x84B40002
Error description: La característica 'SQL_Engine_Core_Inst' de SQL Server no tiene un estado de reparación admitido, ya que nunca se configuró correctamente. Solo las características de instalaciones correctas se pueden reparar. Para continuar, quite la característica especificada.
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=0x2841E06E%401204%402&EvtType=0x2841E06E%401204%402

Feature: SQL Browser
Status: Correcto

Feature: Objeto de escritura de SQL
Status: Correcto

Feature: SDK de conectividad de cliente SQL
Status: Correcto

Feature: Conectividad de cliente SQL
Status: Correcto

Feature: Archivos auxiliares del programa de configuración
Status: Correcto

Seeya Xi-MSFT 15,111 Reputation points Microsoft Vendor

2022-01-26T07:52:59.067+00:00

Hi @David Poma ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya
David Poma 1 Reputation point

2022-01-27T15:16:00.003+00:00

Hello @Seeya Xi-MSFT regarding the problem, I have tried to completely remove the sql programs using the "Uninstall Programs" tool and I have removed the keys referring to sql server using regedit and later I have restarted the machine and despite that it does not work for me installation. I would like to know which file is the key to know the problem in depth, Thank you
Seeya Xi-MSFT 15,111 Reputation points Microsoft Vendor

2022-01-28T01:50:51.407+00:00

Hi @David Poma ,

Do you mean you want to get the setup log to get more details? The detail.txt in below path: %programfiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log\YYYYMMDD_hhmmss\Detail.txt. And you could search 'error' in the file to get some details.
For more information, please check View and Read SQL Server Setup Log Files.

Best regards,
Seeya
David Poma 1 Reputation point

2022-01-28T18:45:03.76+00:00

Hello, I am attaching my details file and now after trying the installation process again, deleting the referring records and sql programs, the new component error code is: 0x851A001A and the decimal output code: -2061893606

169476-detail.txt

Thanks.

Seeya Xi-MSFT 15,111 Reputation points Microsoft Vendor

2022-01-26T07:52:59.067+00:00

Hi @David Poma ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya
David Poma 1 Reputation point

2022-01-27T15:16:00.003+00:00

Hello @Seeya Xi-MSFT regarding the problem, I have tried to completely remove the sql programs using the "Uninstall Programs" tool and I have removed the keys referring to sql server using regedit and later I have restarted the machine and despite that it does not work for me installation. I would like to know which file is the key to know the problem in depth, Thank you
Seeya Xi-MSFT 15,111 Reputation points Microsoft Vendor

2022-01-28T01:50:51.407+00:00

Hi @David Poma ,

Do you mean you want to get the setup log to get more details? The detail.txt in below path: %programfiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log\YYYYMMDD_hhmmss\Detail.txt. And you could search 'error' in the file to get some details.
For more information, please check View and Read SQL Server Setup Log Files.

Best regards,
Seeya
David Poma 1 Reputation point

2022-01-28T18:45:03.76+00:00

Hello, I am attaching my details file and now after trying the installation process again, deleting the referring records and sql programs, the new component error code is: 0x851A001A and the decimal output code: -2061893606

169476-detail.txt

Thanks.

Answer 1

Hi David,

The error 0x84B40002 means that is a failed installation and the way to deal with this case is uninstalling all SQL Server components installed using the following procedure.

http://jermsmit.com/uninstall-of-sql-fails-with-error-about-rsfx-driver/

Once you have uninstalled SQL Server existent components, please try to install again using the following article:

http://www.sqlcoffee.com/SQLServer2014_0005.htm .

Hope this helps.

Answer 2

Hi @David Poma ,

Agree with StacyClark-5656.
You need to uninstall sql server and reinstall. Here I would like to add the process of uninstalling sql server cleanly.
Uninstall an Existing Instance of SQL Server (Setup)
Before reinstall, please follow the below steps to remove all components of previous installed SQL Server completely:

Remove all SQL Server components from 'Programs and Features'
Backup the registry
Delete the following keys in regedit:
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server
Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server
Reboot the machine
In addition, please use an administrator account to reinstall SQL Server on your computer(Right click->run as administrator).

Best regards,
Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Error en la espera del controlador de recuperación del Motor de base de datos. - Exit Code Decimal -2061893606, Código de error: 0x84B40002

2 answers

Activity