Error trying to install SQL Server on my laptop Exit code (Decimal): -2061893606

Anil 21 Reputation points
2022-01-23T18:41:45.987+00:00

Error trying to install SQL Server on my laptop Exit code (Decimal): -2061893606. Error desccription: Wait on te Database Engine recovery handle failed. 2022-01-23 13:19:05 Slp: Running Action: CloseUI
(10) 2022-01-23 13:19:05 Slp: Stop action skipped in UI Mode Quiet
(10) 2022-01-23 13:19:05 Slp: Completed Action: CloseUI, returned True
(10) 2022-01-23 13:19:05 Slp: Completed Action: ExecuteCloseWorkflow, returned True
(10) 2022-01-23 13:19:05 Slp: Completed Action: ExecuteCompleteWorkflow, returned True
(10) 2022-01-23 13:19:05 Slp: SetupTelemetry: Writing Telemetry to Datastore
(10) 2022-01-23 13:19:07 Slp:
(03) 2022-01-23 13:19:07 Slp:
(03) 2022-01-23 13:19:07 Slp: ----------------------------------------------------------------------
(03) 2022-01-23 13:19:07 Slp:
(03) 2022-01-23 13:19:07 Slp: Error result: -2061893606
(03) 2022-01-23 13:19:07 Slp: Result facility code: 1306
(03) 2022-01-23 13:19:07 Slp: Result error code: 26
(03) 2022-01-23 13:19:07 Slp: WER: Application level consent value 'True' was mapped to consent status 'WerConsentApproved'
(03) 2022-01-23 13:19:07 Slp: WER: Result of the submission:: 'WerReportQueued'
(03) 2022-01-23 13:19:07 Slp: WER: Submitted 1 of 1 failures to the Watson data repository
(03) 2022-01-23 13:19:07 Slp: SetupTelemetry: Closing Telemetry Session
(03) 2022-01-23 13:19:07 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(03) 2022-01-23 13:19:07 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\SQMClient
(03) 2022-01-23 13:19:07 Slp: Sco: Attempting to get registry value MachineId
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\150
(10) 2022-01-23 13:19:07 Slp: SetupTelemetry: Not creating telemetry audit log. Value 'UserRequestedLocalAuditDirectory' doesn't exist in 'HKLM\Software\Microsoft\Microsoft SQL Server\150'
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\150
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to get registry value CustomerFeedback
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to get registry value EnableErrorReporting
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\Instance Names
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to open registry subkey SQL
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to get registry value SQLEXPRESS
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\MSSQL15.SQLEXPRESS\CPE
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to get registry value CustomerFeedback
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to get registry value EnableErrorReporting
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\Instance Names
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to open registry subkey OLAP
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\Instance Names
(10) 2022-01-23 13:19:07 Slp: Sco: Attempting to open registry subkey RS
(10) 2022-01-23 13:19:07 Slp: SetupTelemetry: Telemetry has an active session with 76 events.
(01) 2022-01-23 13:19:07 Slp: Process returned -2061893606
(01) 2022-01-23 13:19:07 Slp: Received request to add the following file to Watson reporting: C:\Users\anila\AppData\Local\Temp\tmpB4B0.tmp
(01) 2022-01-23 13:19:07 Slp: SetupTelemetry: Writing Telemetry to Datastore
(01) 2022-01-23 13:19:09 Slp: SetupTelemetry: Closing Telemetry Session
(01) 2022-01-23 13:19:09 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(01) 2022-01-23 13:19:09 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\SQMClient
(01) 2022-01-23 13:19:09 Slp: Sco: Attempting to get registry value MachineId
(01) 2022-01-23 13:19:09 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(01) 2022-01-23 13:19:09 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\150
(01) 2022-01-23 13:19:09 Slp: SetupTelemetry: Not creating telemetry audit log. Value 'UserRequestedLocalAuditDirectory' doesn't exist in 'HKLM\Software\Microsoft\Microsoft SQL Server\150'
(01) 2022-01-23 13:19:09 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(01) 2022-01-23 13:19:09 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\150
(01) 2022-01-23 13:19:09 Slp: Sco: Attempting to get registry value CustomerFeedback

SQL Server | Other
0 comments No comments
{count} votes

Accepted answer
  1. Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator
    2022-01-23T21:03:20.29+00:00

    It did say Windows 10 on the top of the errorlog, but I seem to recall that for some reason Windows 11 is not reported correctly.

    Anyway, for Windows 11 for how to troubleshoot this issue: https://learn.microsoft.com/sv-se/troubleshoot/sql/admin/troubleshoot-os-4kb-disk-sector-size.

    0 comments No comments

4 additional answers

Sort by: Most helpful
  1. Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator
    2022-01-23T20:01:59.83+00:00

    Error description: Wait on the Database Engine recovery handle failed

    This error means that SQL Server failed to start when Setup wanted to run install scripts. To understand why it failed, you need to look in the file C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\LOG\ERRORLOG. Upload it here, if you cannot make sense of it. (Rename it to ERRORLOG.txt to be able to attach it.)

    0 comments No comments

  2. Anil 21 Reputation points
    2022-01-23T20:38:06.49+00:00

  3. Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator
    2022-01-23T20:54:32.663+00:00

    I see that you accepted my Answer, but judging from the errorlog the problem still persists, so it may be better to unaccept my answer, until we have a resolution. Or did the penny drop directly when you saw this line:

    There have been 256 misaligned log IOs which required falling back to synchronous IO

    In that case, I'm impressed!

    Anyway, this has to do with the disk sector size not being what it should be. It has been commonly seen on Windows 11, where the operating system reports in correct data, but I see that you are on Windows 10.

    I have not fully grasped the situation, but what you can try is to go into the SQL Server Configuration Manger and add this startup parameter:

    167536-image.png

    That reads -T1800. Don't forget to press Add and OK. Then retry the installation. This trace flag helps SQL Server to deal with the funky sector size.


  4. Anil 21 Reputation points
    2022-01-23T21:08:39.48+00:00

    Will this trace flag stay - if I uninstall then reinstall?


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.