SQL Server : installation fails with error code 0x851A001A

Question

SQL Server : installation fails with error code 0x851A001A

Fabiana Palmisano 35

Hi,

I am trying to install SQL server 2019 on my PC but I get the error in question.

how can i solve it?

Thanks,

Summary_PC-Fabiana_20230705_104151.txt

Eric 0 Reputation points

2025-05-07T12:22:04.0633333+00:00

Got this error 0x851A001A after installing CU16/CU17 on SQL-Server 2022. Out of curiosity i tried the "Path to executable" of the service in a CMD-Box: "%PATHTOSQLSERVREXE%\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER

That did a kind of reinitialization.

Was able to restart SQL-service after that.

Accepted answer

1 additional answer

Your answer

Eric 0 Reputation points

2025-05-07T12:22:04.0633333+00:00

Got this error 0x851A001A after installing CU16/CU17 on SQL-Server 2022. Out of curiosity i tried the "Path to executable" of the service in a CMD-Box: "%PATHTOSQLSERVREXE%\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER

That did a kind of reinitialization.

Was able to restart SQL-service after that.

Answer 1

Erland Sommarskog 121.4K MVP Volunteer Moderator

I see this message in the log file:

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

This is a generic message that informs us that SQL Server did not start when Setup wanted to run configuration actions.

To understand why it fails, you need to check the SQL Server errorlog (as it says in the message). You find it C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\LOG\ERRORLOG.

If you see a message about 256 unaligned reads towards the end of the file, you are encountering a known issue where Windows 11 reports a disk-sector size that SQL Server cannot cope with. Microsoft has published an article with workarounds for this problem.

If you don't see anything about 256, feel free to upload the ERRORLOG file here. (You will need to rename it to ERRORLOG.txt for it to be accepted.)

mani kanna 0 Reputation points

2024-09-08T05:04:27.6266667+00:00

I received same error code, and i'm not sure how to solve it. Even reinstalled windows. My note book is Ryzen 7 5800H. Kindly help...

Summary_MavhacII-Lenovo_20240908_122602.txt
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2024-09-08T18:43:56.4233333+00:00

House rules: don't piggyback on old threads, but ask a new Question, describing from start to end. Beside the summary file, the file details.txt is a good start for troubleshooting.
ALUMNO - DANIELA ANDREINA DIAZ HERRERA 0 Reputation points

2024-10-14T20:35:30.08+00:00

ERRORLOG.txt
Amir Mohammadpour 0 Reputation points

2025-02-25T21:41:16.4166667+00:00

Hi,

I am trying to install SQL server 2022 on my PC but I get the error in question.

how can i solve it?

Thanks,

ERRORLOG.txt

Summary_Asus_20250225_131324.txt
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2025-02-25T21:48:58.2233333+00:00

You can resolve it by reading my answer above. It has all information you need. Also, please read my comment about house rules above.
Amir Mohammadpour 0 Reputation points

2025-02-25T22:34:45.2633333+00:00

i Edited. Please help because i read but i can't understand!

Tnx
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2025-02-25T22:40:20.35+00:00

Again: please read about the house rules above.
KIEL - Service 2 0 Reputation points

2025-05-25T22:00:11.0366667+00:00
2025-05-26 00:41:17.28 Server Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)

Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 22631: )

2025-05-26 00:41:17.28 Server UTC adjustment: 3:00

2025-05-26 00:41:17.28 Server (c) Microsoft Corporation.

2025-05-26 00:41:17.28 Server All rights reserved.

2025-05-26 00:41:17.28 Server Server process ID is 6468.

2025-05-26 00:41:17.28 Server System Manufacturer: 'LENOVO', System Model: '20TD002MCY'.

2025-05-26 00:41:17.28 Server Authentication mode is MIXED.

2025-05-26 00:41:17.28 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESSNEW\MSSQL\Log\ERRORLOG'.

2025-05-26 00:41:17.28 Server The service account is 'NT Service\MSSQL$SQLEXPRESSNEW'. This is an informational message; no user action is required.

2025-05-26 00:41:17.28 Server Registry startup parameters:

-d C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESSNEW\MSSQL\DATA\master.mdf -e C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESSNEW\MSSQL\Log\ERRORLOG -l C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESSNEW\MSSQL\DATA\mastlog.ldf

2025-05-26 00:41:17.28 Server Command Line Startup Parameters:

-s "SQLEXPRESSNEW"

2025-05-26 00:41:17.39 Server SQL Server detected 1 sockets with 4 cores per socket and 8 logical processors per socket, 8 total logical processors; using 8 logical processors based on SQL Server licensing. This is an informational message; no user action is required.

2025-05-26 00:41:17.43 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2025-05-26 00:41:17.45 Server Detected 16082 MB of RAM. This is an informational message; no user action is required.

2025-05-26 00:41:17.47 Server Using conventional memory in the memory manager.

2025-05-26 00:41:17.47 Server Page exclusion bitmap is enabled.

2025-05-26 00:41:17.68 Server Buffer Pool: Allocating 4194304 bytes for 2361677 hashPages.

2025-05-26 00:41:18.31 Server Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)

2025-05-26 00:41:18.80 Server Buffer pool extension is already disabled. No action is necessary.

2025-05-26 00:41:19.41 Server Query Store settings initialized with enabled = 1,

2025-05-26 00:41:19.42 Server The maximum number of dedicated administrator connections for this instance is '1'

2025-05-26 00:41:19.42 Server This instance of SQL Server last reported using a process ID of 4052 at 5/26/2025 12:12:15 AM (local) 5/25/2025 9:12:15 PM (UTC). This is an informational message only; no user action is required.

2025-05-26 00:41:19.43 Server Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.

2025-05-26 00:41:19.44 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.

2025-05-26 00:41:19.45 Server In-Memory OLTP initialized on standard machine.

2025-05-26 00:41:19.46 Server [INFO] Created Extended Events session 'hkenginexesession'

2025-05-26 00:41:19.46 Server Database Instant File Initialization: disabled. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.

2025-05-26 00:41:19.47 Server Total Log Writer threads: 2. This is an informational message; no user action is required.

2025-05-26 00:41:19.48 Server clwb is selected for pmem flush operation.

2025-05-26 00:41:19.48 Server Software Usage Metrics is disabled.

2025-05-26 00:41:19.49 spid9s Starting up database 'master'.

2025-05-26 00:41:19.59 Server CLR version v4.0.30319 loaded.

2025-05-26 00:41:19.63 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319.

Answer 2

Anonymous

Hi @Fabiana Palmisano

Based on the error message, I found a post that encountered the same error, you can refer to it.

https://stackoverflow.com/questions/71003281/sql-server-installation-fails-with-error-code-0x851a001a-wait-on-the-databas

If this can not help you, you need to check the error log according to Erland's advice.

Best regards,

Percy Tang

Marco Bandera 0 Reputation points

2024-11-03T09:11:37.5466667+00:00

I have the same problem, but I haven't find in the LOG the same information.

this is my log.

Could you help me?

Thanks
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2024-11-03T16:45:12.4666667+00:00

House rules: don't piggyback on old thread, but ask a new question. Please make sure that you include all relevant logs. And verify after the posting that the files you intended to include are actually there.

Share via

SQL Server : installation fails with error code 0x851A001A

1 additional answer

Your answer