[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
SQL Server 2022  Exit code(Decimal) -2061893606

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

SQL Server 2022 Exit code(Decimal): -2061893606.


Applies to: SQL Server 2022 on Windows.

Date created: May 12, 2024.
 

Problem Description.
 

Trying to install SQL Server 2022 Express Edition you may receive the following error from SQL Server setup.
 

Unable to install SQL Server (setup.exe).
Exit code(Decimal): -2061893606. Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

 


 

 

Cause.


Some users think this error means setup program unable to download SQL Server media, but in reality this error really means that SQL Server service did not start when Setup tried to do configuration tasks. As suggested by the error message you can examine SQL Server error log to better understand why the service was not able to start. The location of the log should be the following: C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\LOG\ERRORLOG.

If you see the following error message on the SQL Server error log please try the solution we share with you in this troubleshooting guide.

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

The cause of the error is that some storage devices and device drivers expose a disk sector size greater than the supported 4-KB sector size. When this occurs, SQL Server will be unable to start due to the unsupported file system as SQL Server currently supports sector storage sizes of 512 bytes and 4 KB.

 

Workaround/Solution.


One solution is to open the Windows registry editor and to the following steps:

bulletNavigate to Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device.
bulletOn the Edit menu, point to New, and then select Multi-String value. Name it ForcedPhysicalSectorSizeInBytes.
bulletModify the new value, type in * 4095. Select OK and close the Registry editor.

 

Another option is to open the Windows command prompt as administrator and run the following command:


REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" /t REG_MULTI_SZ /d "* 4095" /f
 

 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.