Unable to install SQL Server 2022

Question

I encountered some errors while installing SQL Server, can anyone give me some solutions? Below is the error log.



2023-05-28 23:50:30.15 Server      Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) 
	Oct  8 2022 05:58:25 
	Copyright (C) 2022 Microsoft Corporation
	Express Edition (64-bit) on Windows 10 Home Single Language 10.0 <X64> (Build 22621: )

2023-05-28 23:50:30.15 Server      UTC adjustment: 8:00
2023-05-28 23:50:30.15 Server      (c) Microsoft Corporation.
2023-05-28 23:50:30.15 Server      All rights reserved.
2023-05-28 23:50:30.15 Server      Server process ID is 21264.
2023-05-28 23:50:30.15 Server      System Manufacturer: 'LENOVO', System Model: '82K2'.
2023-05-28 23:50:30.15 Server      Authentication mode is WINDOWS-ONLY.
2023-05-28 23:50:30.15 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2023-05-28 23:50:30.15 Server      The service account is 'NT Service\MSSQL$SQLEXPRESS'. This is an informational message; no user action is required.
2023-05-28 23:50:30.15 Server      Registry startup parameters: 
	 -d C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\master.mdf
	 -e C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Log\ERRORLOG
	 -l C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
2023-05-28 23:50:30.15 Server      Command Line Startup Parameters:
	 -s "SQLEXPRESS"
	 -m "SqlSetup"
	 -Q
	 -q "SQL_Latin1_General_CP1_CI_AS"
	 -T 4022
	 -T 4010
	 -T 3659
	 -T 3610
	 -T 8015
	 -d "C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Template Data\master.mdf"
	 -l "C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Template Data\mastlog.ldf"
2023-05-28 23:50:30.16 Server      SQL Server detected 1 sockets with 8 cores per socket and 16 logical processors per socket, 16 total logical processors; using 8 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2023-05-28 23:50:30.16 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2023-05-28 23:50:30.16 Server      Detected 14188 MB of RAM. This is an informational message; no user action is required.
2023-05-28 23:50:30.16 Server      Using conventional memory in the memory manager.
2023-05-28 23:50:30.16 Server      Detected pause instruction latency: 32 cycles.
2023-05-28 23:50:30.16 Server      Page exclusion bitmap is enabled.
2023-05-28 23:50:30.24 Server      Buffer Pool: Allocating 1048576 bytes for 1026927 hashPages.
2023-05-28 23:50:30.24 Server      Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2023-05-28 23:50:30.26 Server      Buffer pool extension is already disabled. No action is necessary.
2023-05-28 23:50:30.27 Server      CPU vectorization level(s) detected:  SSE SSE2 SSE3 SSSE3 SSE41 SSE42 AVX AVX2 POPCNT BMI1 BMI2
2023-05-28 23:50:30.28 Server      Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2023-05-28 23:50:30.29 Server      Query Store settings initialized with enabled = 1, 
2023-05-28 23:50:30.29 Server      The maximum number of dedicated administrator connections for this instance is '1'
2023-05-28 23:50:30.29 Server      This instance of SQL Server last reported using a process ID of 2460 at 28/5/2023 11:50:28 PM (local) 28/5/2023 3:50:28 PM (UTC). This is an informational message only; no user action is required.
2023-05-28 23:50:30.30 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.
2023-05-28 23:50:30.30 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.
2023-05-28 23:50:30.30 Server      Lock partitioning is enabled.  This is an informational message only. No user action is required.
2023-05-28 23:50:30.30 Server      In-Memory OLTP initialized on lowend machine.
2023-05-28 23:50:30.31 Server      [INFO] Created Extended Events session 'hkenginexesession'
2023-05-28 23:50:30.31 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.
2023-05-28 23:50:30.31 Server      Total Log Writer threads: 2, Node CPUs: 4, Nodes: 1, Log Writer threads per CPU: 1, Log Writer threads per Node: 2
2023-05-28 23:50:30.31 Server      Database Mirroring Transport is disabled in the endpoint configuration.
2023-05-28 23:50:30.31 Server      clwb is selected for pmem flush operation.
2023-05-28 23:50:30.31 Server      Software Usage Metrics is disabled.
2023-05-28 23:50:30.31 spid26s     Warning ******************
2023-05-28 23:50:30.31 spid26s     SQL Server started in single-user mode. This an informational message only. No user action is required.
2023-05-28 23:50:30.32 spid26s     Starting up database 'master'.
2023-05-28 23:50:30.32 spid26s     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.SQLEXPRESS\MSSQL\Template Data\master.mdf.
2023-05-28 23:50:30.33 spid26s     05/28/23 23:50:30 Stack Overflow Dump not possible - Exception c00000fd EXCEPTION_STACK_OVERFLOW at 0x00007FFF02E2F009
2023-05-28 23:50:30.33 spid26s     SqlDumpExceptionHandler: Address=0x00007FFF02E2F009 Exception Code = c00000fd
2023-05-28 23:50:30.33 spid26s     Rax=0000000000001118 Rbx=00000000094aa180 Rcx=0000000013808040 Rdx=0000000014499000
2023-05-28 23:50:30.33 spid26s     Rsi=0000000014499000 Rdi=0000000000004000 Rip=0000000002e2f009 Rsp=000000000fe12f20
2023-05-28 23:50:30.33 spid26s     Rbp=000000000fe11f20 EFlags=0000000000010206
2023-05-28 23:50:30.33 spid26s     cs=0000000000000033 ss=000000000000002b ds=000000000000002b
es=000000000000002b fs=0000000000000053 gs=000000000000002b
2023-05-28 23:50:30.41 spid26s     Frame 0: 0x00007FFF001A5F16
2023-05-28 23:50:30.41 spid26s     Frame 1: 0x00007FFF010DD6B6
2023-05-28 23:50:30.41 spid26s     Frame 2: 0x00007FFF001A58A0
2023-05-28 23:50:30.41 spid26s     Frame 3: 0x00007FFF08179C16
2023-05-28 23:50:30.41 spid26s     Frame 4: 0x00007FFF08114BDC
2023-05-28 23:50:30.41 spid26s     Frame 5: 0x00007FFF08114E5B
2023-05-28 23:50:30.41 spid26s     Frame 6: 0x00007FFFF8C1F285
2023-05-28 23:50:30.41 spid26s     Frame 7: 0x00007FFFF8C13970
2023-05-28 23:50:30.41 spid26s     Frame 8: 0x00007FFFF8C13388
2023-05-28 23:50:30.41 spid26s     Frame 9: 0x00007FFFF8C14268
2023-05-28 23:50:30.41 spid26s     Frame 10: 0x00007FFFF8C1FE41
2023-05-28 23:50:30.41 spid26s     Frame 11: 0x00007FF80FE33CFF
2023-05-28 23:50:30.41 spid26s     Frame 12: 0x00007FF80FDAE456
2023-05-28 23:50:30.41 spid26s     Frame 13: 0x00007FF80FE32CEE
2023-05-28 23:50:30.41 spid26s     Frame 14: 0x00007FFF02E2F009
2023-05-28 23:50:30.41 spid26s     Frame 15: 0x00007FFF03FCA79F
2023-05-28 23:50:30.41 spid26s     
2023-05-28 23:50:30.41 spid26s     TotalPhysicalMemory = 14877265920, AvailablePhysicalMemory = 3850240000
2023-05-28 23:50:30.41 spid26s     AvailableVirtualMemory = 140723399794688, AvailablePagingFile = 6495600640
2023-05-28 23:50:30.41 spid26s     Stack Signature for the dump is 0x0000000131620EC3
2023-05-28 23:50:30.41 Server      CLR version v4.0.30319 loaded.
2023-05-28 23:50:30.45 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
2023-05-28 23:50:30.91 spid26s     External dump process return code 0x20000001.
External dump process returned no errors.
2023-05-28 23:50:30.92 spid26s     Unable to create stack dump file due to stack shortage (ex_terminator - Last chance exception handling)
2023-05-28 23:50:30.92 spid26s     Stack Signature for the dump is 0x0000000000000000
2023-05-28 23:50:30.92 spid26s     CDmpClient::ExecuteAllCallbacks started.
2023-05-28 23:50:30.92 spid26s     XE_DumpCallbacks is executing...
2023-05-28 23:50:30.94 spid26s     DumpCallbackSOS is executing...
2023-05-28 23:50:30.94 spid26s     DumpCallbackEE is executing...
2023-05-28 23:50:30.94 spid26s     DumpCallbackSE is executing...
2023-05-28 23:50:30.94 spid26s     DumpCallbackSEAM is executing...
2023-05-28 23:50:30.94 spid26s     DumpCallbackSSB is executing...
2023-05-28 23:50:30.95 spid26s     DumpCallbackQE is executing...
2023-05-28 23:50:30.95 spid26s     DumpCallbackFullText is executing...
2023-05-28 23:50:30.95 spid26s     DumpCallbackSQLCLR is executing...
2023-05-28 23:50:30.95 spid26s     DumpCallbackHk is executing...
2023-05-28 23:50:30.96 spid26s     DumpCallbackRepl is executing...
2023-05-28 23:50:30.96 spid26s     DumpCallbackPolyBase is executing...
2023-05-28 23:50:30.96 spid26s     CDmpClient::ExecuteAllCallbacks completed. Time elapsed: 0 seconds.
2023-05-28 23:50:31.50 spid26s     External dump process return code 0x20000001.
External dump process returned no errors.

Answer 1

2023-05-28 23:50:30.32 spid26s 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.SQLEXPRESS\MSSQL\Template Data\master.mdf.

You are running into a known issue where Windows 11 for certain disk drives reports a sector size that SQL Server cannot cope with. Microsoft has published this article with workarounds.

Answer 2

Hi @Chow Sing Hong,

As Erland Sommarskog said that it is a known issue, please follow the article to resolve the issue.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.