question

KZS-2215 avatar image
1 Vote"
KZS-2215 asked Yufeishao-msft commented

Can't install SQLServer on Windows server 2022 but no problem in Server 2019

I clean installed Windows server 2022 and I can't install SQL Server 2019. I receive error
"Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes."

The same server was working without problem with Windows server 2019 and Microsoft Sql 2019

I attached the log

138268-detail.txt


sql-server-general
detail.txt (2.1 MiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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".

0 Votes 0 ·

Could you please validate all the answers so far and provide any update?
If all of them are not working or helpful, please provide more sample data or details about your issue.
Please remember to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.

0 Votes 0 ·
Yufeishao-msft avatar image
1 Vote"
Yufeishao-msft answered

Hi @KZS-2215

The possible cause is a corruptied user profile for the user account used to start the database.
When you come to Server Configuration page, change the Account Name of SQL Server Database Engine to NT AUTHORITY\NETWORK SERVICE (if it failed, you can also try to ues NT AUTHORITY\SYSTEM)

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KZS-2215 avatar image
1 Vote"
KZS-2215 answered

I tried both Account name and still the same error

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
1 Vote"
ErlandSommarskog answered

This error message means that SQL Server does not start, when Setup wants to run installation scripts.

You need to look in the errorlog file to find more information. You find it in C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\LOG\ERRORLOG assuming a default instance.

When Yufeishao suggested a corrupted user profile, it was a shot from a hip. It is a common reason, but you really need to look at the errorlog first.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KZS-2215 avatar image
0 Votes"
KZS-2215 answered Yufeishao-msft commented

Unfortunately I wasn't able to fix the problem with Windows 2022. Tried all fixes I found without success.
I had to use Windows 2019 to fix the problem and be able to use MSSQL.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I just give you some advice:

you can uninstall this SQL Server instance and reinstall it again, make sure to remove all SQL Server related files from the system as well as the registry,https://www.mssqltips.com/sqlservertip/4050/cleanly-uninstalling-stubborn-sql-server-components/

https://www.mssqltips.com/sqlservertip/4526/sql-server-install-error-wait-on-the-database-engine-recovery-handle-failed/

0 Votes 0 ·