After upgrading to Windows 11, the Sql Server crashes.

Question

After upgrading to Windows 11, the Sql Server crashes.

Jan Vávra 466

I had originally a Sql Server 2019 version. After upgrade, it didn't start. I uninstalled it and installed Sql Server version 2022. But this version is also unable to start.

I tried to run it in a single user mode without any success.
One weird thing is it still claims I am still running Windows 10,
ERRORLOG.txt

systeminfo returned

C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Binn>systeminfo

Host Name:                 VAVRA-PC
OS Name:                   Microsoft Windows 11 Enterprise
OS Version:                10.0.22631 N/A Build 22631
OS Manufacturer:           Microsoft Corporation

Viorel 127.1K Reputation points

2025-03-19T15:38:22.5633333+00:00

What details about the crash were observed?

Answer accepted by question author

Erland Sommarskog 135.7K MVP Volunteer Moderator

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.

Jan Vávra 466 Reputation points

2025-03-20T08:20:10.32+00:00
Thank you very much. I made these steps:

fsutil fsinfo sectorinfo c:
originally returned
PhysicalBytesPerSectorForPerformance : 16384

after adding a registry key

Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device:

and restarting Windows it newly shows:

PhysicalBytesPerSectorForPerformance : 4096

The sql server then failed to start. But in the ERROR.log was nothing about process crash, there was:

2025-03-20 09:05:19.05 spid50s FCB::Open failed: Could not open file D:\dbs\sh\5uj5\1008_054209\cmd\11\obj\x64retail\sql\mkmastr\databases\mkmastr.nativeproj\model.mdf for file number 1. OS error: 3(Systém nemůže nalézt uvedenou cestu.).

So I recreated master and other basic databases using

f:\>setup.exe /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS="vavra"

Finally, the sql server has started ;-)
Erland Sommarskog 135.7K Reputation points MVP Volunteer Moderator

2025-03-20T21:40:32.23+00:00

Great to hear that you were able to work past the incorrect file path. (Which I believe comes from the template.) I'm not sure I would have figured that out myself.

1 additional answer

Your answer

Viorel 127.1K Reputation points

2025-03-19T15:38:22.5633333+00:00

What details about the crash were observed?
Jan Vávra 466 Reputation points

2025-03-20T08:20:10.32+00:00

Thank you very much. I made these steps:

fsutil fsinfo sectorinfo c:
originally returned
PhysicalBytesPerSectorForPerformance : 16384

after adding a registry key

Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device:

and restarting Windows it newly shows:

PhysicalBytesPerSectorForPerformance : 4096

The sql server then failed to start. But in the ERROR.log was nothing about process crash, there was:

2025-03-20 09:05:19.05 spid50s FCB::Open failed: Could not open file D:\dbs\sh\5uj5\1008_054209\cmd\11\obj\x64retail\sql\mkmastr\databases\mkmastr.nativeproj\model.mdf for file number 1. OS error: 3(Systém nemůže nalézt uvedenou cestu.).

So I recreated master and other basic databases using

f:\>setup.exe /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS="vavra"

Finally, the sql server has started ;-)
Erland Sommarskog 135.7K Reputation points MVP Volunteer Moderator

2025-03-20T21:40:32.23+00:00

Great to hear that you were able to work past the incorrect file path. (Which I believe comes from the template.) I'm not sure I would have figured that out myself.

Answer 1

Jan Vávra 466

I can see a STACK OVERFLOW exception in log from another run ...
2025-03-19 16:46:22.98 spid44s 03/19/25 16:46:22 Stack Overflow Dump not possible - Exception c00000fd EXCEPTION_STACK_OVERFLOW at 0x00007FFAD071F009

ERRORLOG.2.txt

Viorel 127.1K Reputation points

2025-03-19T17:10:03.44+00:00
Maybe this is a similar problem:

https://learn.microsoft.com/en-us/answers/questions/1288063/sql-server-2022-installation-error-on-windows-11-w