SQL SERVER 2019 INSTALLATION ERROR EXIT CODE 2061893606

marwen froua 0

I tried installing SQL SERVER 2022 before installing 2019 version but i had the same problem, im running on windows 11 , i already tried changing the registry for the sector size to * 4095 but in vain heres my log file and the screenshot User's image

2 answers

Erland Sommarskog 109.9K Reputation points MVP

2023-11-01T22:09:03.48+00:00

The message Wait on the Database Engine recovery handle failed is a generic error that means that SQL Server did not start when Setup wanted to run configuration steps. To understand why it did not start, you need to look in the SQL Server errorlog, which you find in C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\LOG\ERRORLOG.

If you see a message about 256 misaligned reads, you are running into a known issue where Windows 11 for some disk drives reports a sector size that SQL Server does not cope with. Microsoft has published an article with workarounds for the problem.

Since you say that you have already changed the disk-sector size, you are maybe running into something else. feel free to upload the errorlog here, so we can look at it. You will need to rename to ERRORLOG.txt for the forum software to accept it.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
LiHongMSFT-4306 26,621 Reputation points

2023-11-02T06:07:14.86+00:00

Hi @marwen froua

How about start SQL Server by specifying the trace flag 1800. For more information, see DBCC TRACEON. This trace flag isn't enabled by default. Trace flag 1800 forces SQL Server to use 4 KB as the sector size for all read and write operations. When you are running SQL Server on disks with physical sector size greater than 4 KB, using the trace flag 1800 will simulate a native 4 KB drive, which is the supported sector size for SQL Server.

Best regards,

Cosmog Hong
Please sign in to rate this answer.
marwen froua 0 Reputation points

2023-11-04T11:22:24.68+00:00

this is my log file that u spiecified under C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\LOG\ERRORLOG.

Also already tried running the trace flag 1800 and it didnt workERRORLOG.txt

Erland Sommarskog 109.9K Reputation points MVP

2023-11-04T22:04:04.51+00:00

You are running into a different issue that I unfortunately do not know the cause or the solution for. The beginning of your errorlog looks like this:

Which is how it should look like once your installation has completed and you are running SQL Server normally. But at this point, during Setup, it should look something like this:

That is, there should be a lot of special trace flags. I don't know what all them does, but some of them tell SQL Server to change the path for the system databases from the one they have on the installation media to your install folder. But since these flags are missing, SQL Server is trying the installation-media paths, and these paths do not exist on your computer, and therefore SQL Server cannot start.

But why are these startup options missing? That I don't know.

Have you made more than one installation attempt? Are there old ERRORLOG files (ERRORLOG.1, ERRORLOG.2 etc.) If so, can you share them as well? You said you had tried trace flag 1800? Could you inadvertently have deleted the other startup flags when you did this?

Also, can you attach detail.txt, which should be in install folder in C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log, where there is one folder per installation attempt.

marwen froua 0 Reputation points

2023-11-05T08:01:24.6833333+00:00

i already attached detail.text in the main thread , i also tried uninstalling and reinstalling a few times but thats because i had the installation error at the first place

Erland Sommarskog 109.9K Reputation points MVP

2023-11-05T13:46:54.6866667+00:00

Sorry, I did not observe the file at the top.

However, the detail.txt and the errorlog are not from the same occasion. Could you try to find the detail.txt that matches the ERRORLOG you posted? (There are timestamps in both.) And as I said, share any ERRORLOG you have around.

Then again, maybe this error with the missing startup parameters is due to the re-install attempt? Maybe you should uninstall and clean up the registry of anything related to SQL Server?

I like to point out one important thing: No one here is an expert in reading these verbose log files. We have learnt to recognise a few situations, but in many case we can at best make half-intelligent guesses of what is going on. If we were to run into these issues ourselves, we would also have a problem to figure out how to solve it. But in that situation we would at least have full access to the computer where the problem occurs. I like to say this to get your expectations right.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SQL SERVER 2019 INSTALLATION ERROR EXIT CODE 2061893606

2 answers

Your answer