SQL Server 2019 Standard Setup cannot complete installation

lichaowen9

Format the hard disk and specify the sector size; the best way is to repartition a disk.

Use the command to forcibly modify the parameter to simulate a sector size of 4KB.

Right-click and run PowerShell as an administrator, and enter the command:

New-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes" -PropertyType MultiString -Force -Value "* 4095"

Continue to enter the command to check whether the modification is successful:

Get-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes"

This is the last step. Don't relax, or you'll go back to the novice village.

Restart the computer. After completion, right-click and run PowerShell in administrator mode, enter the command, and check whether the sector has been changed back;

Get-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes"

Congratulations! The installation environment has been set up. Start installing SQL Server; don't disconnect from the network during the process. Don't disconnect from the network. Don't disconnect from the network!!!

Formatting harddisk is not needed, solution provided myself some weeks ago by myself in English:

https://support.industry.siemens.com/forum/be/en/posts/wincc-v7-5-sp2-fault-installing-sql-server-2016/318429/?page=0&pageSize=10