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

Question

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
错误程序包全名:

Answer 1

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.