Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893606

Question

2024-10-09 21:39:15.09 Server Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64)

Oct  8 2022 05:58:25 

Copyright (C) 2022 Microsoft Corporation

Enterprise Evaluation Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 22631: ) (Hypervisor)

2024-10-09 21:39:15.09 Server UTC adjustment: 1:00

2024-10-09 21:39:15.09 Server (c) Microsoft Corporation.

2024-10-09 21:39:15.09 Server All rights reserved.

2024-10-09 21:39:15.09 Server Server process ID is 23796.

2024-10-09 21:39:15.09 Server System Manufacturer: 'LENOVO', System Model: '82KD'.

2024-10-09 21:39:15.09 Server Authentication mode is WINDOWS-ONLY.

2024-10-09 21:39:15.09 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER02\MSSQL\Log\ERRORLOG'.

2024-10-09 21:39:15.09 Server The service account is 'NT Service\MSSQL$MSSQLSERVER02'. This is an informational message; no user action is required.

2024-10-09 21:39:15.09 Server Registry startup parameters:

 -d C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER02\MSSQL\DATA\master.mdf

 -e C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER02\MSSQL\Log\ERRORLOG

 -l C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER02\MSSQL\DATA\mastlog.ldf

2024-10-09 21:39:15.09 Server Command Line Startup Parameters:

 -s "MSSQLSERVER02"

 -m "SqlSetup"

 -Q

 -q "SQL_Latin1_General_CP1_CI_AS"

 -T 4022

 -T 4010

 -T 3659

 -T 3610

 -T 8015

2024-10-09 21:39:15.09 Server SQL Server detected 1 sockets with 6 cores per socket and 12 logical processors per socket, 12 total logical processors; using 12 logical processors based on SQL Server licensing. This is an informational message; no user action is required.

2024-10-09 21:39:15.09 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2024-10-09 21:39:15.09 Server Detected 5989 MB of RAM. This is an informational message; no user action is required.

2024-10-09 21:39:15.09 Server Using conventional memory in the memory manager.

2024-10-09 21:39:15.09 Server Detected pause instruction latency: 21 cycles.

2024-10-09 21:39:15.09 Server Page exclusion bitmap is enabled.

2024-10-09 21:39:15.20 Server Buffer Pool: Allocating 1048576 bytes for 958320 hashPages.

2024-10-09 21:39:15.20 Server Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)

2024-10-09 21:39:15.23 Server Buffer pool extension is already disabled. No action is necessary.

2024-10-09 21:39:15.27 Server CPU vectorization level(s) detected: SSE SSE2 SSE3 SSSE3 SSE41 SSE42 AVX AVX2 POPCNT BMI1 BMI2

2024-10-09 21:39:15.29 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.

2024-10-09 21:39:15.31 Server Query Store settings initialized with enabled = 1,

2024-10-09 21:39:15.32 Server The maximum number of dedicated administrator connections for this instance is '1'

2024-10-09 21:39:15.33 Server Node configuration: node 0: CPU mask: 0x0000000000000fff:0 Active CPU mask: 0x0000000000000fff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.

2024-10-09 21:39:15.34 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.

2024-10-09 21:39:15.35 Server In-Memory OLTP initialized on lowend machine.

2024-10-09 21:39:15.37 Server [INFO] Created Extended Events session 'hkenginexesession'

2024-10-09 21:39:15.37 Server Database Instant File Initialization: enabled. 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.

2024-10-09 21:39:15.37 Server Total Log Writer threads: 2, Node CPUs: 6, Nodes: 1, Log Writer threads per CPU: 1, Log Writer threads per Node: 2

2024-10-09 21:39:15.38 Server Database Mirroring Transport is disabled in the endpoint configuration.

2024-10-09 21:39:15.38 Server clwb is selected for pmem flush operation.

2024-10-09 21:39:15.38 Server Software Usage Metrics is disabled.

2024-10-09 21:39:15.38 spid34s Warning ******************

2024-10-09 21:39:15.38 spid34s SQL Server started in single-user mode. This an informational message only. No user action is required.

2024-10-09 21:39:15.38 spid34s Starting up database 'master'.

2024-10-09 21:39:15.39 spid34s There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER02\MSSQL\DATA\master.mdf.

2024-10-09 21:39:15.40 spid34s Unable to create stack dump file due to stack shortage (ex_terminator - Last chance exception handling)

2024-10-09 21:39:15.40 spid34s Stack Signature for the dump is 0x0000000000000000

2024-10-09 21:39:15.40 spid34s CDmpClient::ExecuteAllCallbacks started.

2024-10-09 21:39:15.40 spid34s XE_DumpCallbacks is executing...

2024-10-09 21:39:15.41 spid34s DumpCallbackSOS is executing...

2024-10-09 21:39:15.41 spid34s DumpCallbackEE is executing...

2024-10-09 21:39:15.41 spid34s DumpCallbackSE is executing...

2024-10-09 21:39:15.41 spid34s DumpCallbackSEAM is executing...

2024-10-09 21:39:15.41 spid34s DumpCallbackSSB is executing...

2024-10-09 21:39:15.43 spid34s DumpCallbackQE is executing...

2024-10-09 21:39:15.43 spid34s DumpCallbackFullText is executing...

2024-10-09 21:39:15.43 spid34s DumpCallbackSQLCLR is executing...

2024-10-09 21:39:15.43 spid34s DumpCallbackHk is executing...

2024-10-09 21:39:15.43 spid34s DumpCallbackRepl is executing...

2024-10-09 21:39:15.43 spid34s DumpCallbackPolyBase is executing...

2024-10-09 21:39:15.43 spid34s CDmpClient::ExecuteAllCallbacks completed. Time elapsed: 0 seconds.

2024-10-09 21:39:15.51 Server CLR version v4.0.30319 loaded.

2024-10-09 21:39:15.57 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319.

2024-10-09 21:39:16.31 spid34s External dump process return code 0x20000001.

External dump process returned no errors.

Answer 1

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.

Answer 2

Hi，Tahirli, Zirian

2024-10-09 21:39:15.39 spid34s There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER02\MSSQL\DATA\master.mdf.

It can be seen that this is a question about the disk sector size of Windows 11.

You can follow the prompts in the article to add a registry entry to forcibly simulate the sector size as 4 KB and retry the installation.

Regards

Mikey Qiao

---

If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.