debugsqlMinor
Cannot install Sql Server 2019 on Windows Server 2022
Viewed 0 times
cannotinstall2022sql2019windowsserver
Problem
On a brand new install of Windows Server 2022 standard, I am trying to install SQL Server 2019.
I downloaded the eval version, put my key in and proceeded to install the Database Engine. Default instance. Tried both mixed and windows auth.
I have tried many of the different service accounts.
At the end of the install, I still get the same error: "Wait on the Database Engine recovery handle failed".
Each time I have tried uninstalling SQL Server, reinstalled and tried another account type. I have also tried setting the account no the SQL Server process itself to different account types but nothing is working. I have tried everything listed here too but nothing gets the installer to succeed.
Is anyone else able to install SQL Server 2019 on Windows Server 2022? It should be supported but this is crazy that it won't install.
There is literally nothing else installed on this machine.
Some logs:
```
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2061893606
Start time: 2021-10-14 12:00:52
End time: 2021-10-14 12:13:30
Requested action: Install
Setup completed with required actions for features.
Troubleshooting information for those features:
Next step for SQLEngine: Use the following information to resolve the error, uninstall this feature, and then run the
I downloaded the eval version, put my key in and proceeded to install the Database Engine. Default instance. Tried both mixed and windows auth.
I have tried many of the different service accounts.
- Default
- NT Authority\SYSTEM
- NT AUTHORITY\LOCAL SERVICE
- NT AUTHORITY\NETWORK SERVICE
At the end of the install, I still get the same error: "Wait on the Database Engine recovery handle failed".
TITLE: Microsoft SQL Server 2019 Setup
------------------------------
The following error has occurred:
Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0xD15B4EB2%25400x4BDAF9BA%25401306%254026
------------------------------
BUTTONS:
OK
------------------------------Each time I have tried uninstalling SQL Server, reinstalled and tried another account type. I have also tried setting the account no the SQL Server process itself to different account types but nothing is working. I have tried everything listed here too but nothing gets the installer to succeed.
Is anyone else able to install SQL Server 2019 on Windows Server 2022? It should be supported but this is crazy that it won't install.
There is literally nothing else installed on this machine.
Some logs:
```
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2061893606
Start time: 2021-10-14 12:00:52
End time: 2021-10-14 12:13:30
Requested action: Install
Setup completed with required actions for features.
Troubleshooting information for those features:
Next step for SQLEngine: Use the following information to resolve the error, uninstall this feature, and then run the
Solution
This is a new issue by installing SQL server on either windows 11 or windows server 2022.
SQL server require a correct value of storage drive sector size, both logical and physical and it seems this is main issue on windows 11 and windows server 2022 on new generation drives like M ssd.
Solution:
Install sql server on another drive, like an external drive
Update: Better solution
just use a virtual drive (VHD) for sql databases, not sql itself
SQL server require a correct value of storage drive sector size, both logical and physical and it seems this is main issue on windows 11 and windows server 2022 on new generation drives like M ssd.
Solution:
Install sql server on another drive, like an external drive
Update: Better solution
just use a virtual drive (VHD) for sql databases, not sql itself
Context
StackExchange Database Administrators Q#301118, answer score: 2
Revisions (0)
No revisions yet.