windows11 with m.2 harddisk cannot install sqlserver2019 Express 使用m.2硬盘windows11,无法安装sqlserver2019 Express

ssboy 1 Reputation point
2022-04-20T08:47:51.807+00:00

windows11 with m.2 harddisk cannot install sqlserver2019 Express
使用m.2硬盘windows11,无法安装sqlserver2019 Express

错误应用程序名称: sqlservr.exe,版本: 2019.150.2000.5,时间戳: 0x5d8a9215
错误模块名称: ntdll.dll,版本: 10.0.22000.527,时间戳: 0x931cda92
异常代码: 0xc0000005
错误偏移量: 0x00000000000a85f7
错误进程 ID: 0x22dc
错误应用程序启动时间: 0x01d85491c5d2b9db
错误应用程序路径: C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Binn\sqlservr.exe
错误模块路径: C:\Windows\SYSTEM32\ntdll.dll
报告 ID: b08d6e53-dad4-41fa-8d9e-7d494f6f816c
错误程序包全名:

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,584 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,051 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. YufeiShao-msft 7,051 Reputation points
    2022-04-21T08:47:16.013+00:00

    Hi @ssboy ,

    There is one issue that SQL Server 2019 not working when installing on Windows 11, one example can be found in the forum:

    https://learn.microsoft.com/en-us/answers/questions/541099/sql-server-2019-windows-11.html?page=2&pageSize=10&sort=oldest

    This issue seems to be due to a change in how Windows handles the reported sector size for certain NvMe SSDs

    Some potential workarounds for the issue mentioned in that forum thread and/or found through support cases were to install SQL on a secondary drive (if able) that is a separate physical disk from the system’s C: drive, creating a VHD to use for the SQL Server installation, or enabling TF1800. There are additional documentation updates planned to provide more information regarding this scenario.

    -------------

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.