SQL Server Standard 2019 Installation Results: Restart Windows 11 and Install SQL Server 2019.Get-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes" Verify the following on PowerShell (run as Administrator).New-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes" -PropertyType MultiString -Force -Value "* 4095" Run the following on PowerShell (run as Administrator).REG QUERY "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" Verify as follows on CMD Prompt (run as Administrator):."HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" /t REG_MULTI_SZ /d "* 4095" /f Run the following on CMD Prompt (run as Administrator).Change Registry (run as Administrator) as follows:Ĭomputer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device.I followed the following steps as recommended by the Gurus (to Fix “Sector Size) The net result is that I have no option but to somehow get SQL Server 2019 to be successfully installed on Windows 11 in the above environment.Microsoft Website clearly says that SQL Server 2019 is compatible with Windows 11 (RTM) – so we should safely rule out the issues of Windows 11 pre-release version incompatibility.It seems that this issue is not isolated to the Mac 2021 as even someone using a Samsung Laptop with 1TB SSD is facing the same issue.The Gurus say: Windows 11 verifies (this is not done by Windows 10) and returns the “Sector Size” and if it is higher than 4K (4096 Bytes), SQL Server installation fails.Even if I sign up for “Windows Insider Program”, Windows 10 ISO File is not available for the above environment.SQL Server 2019 can be installed successfully on Windows 10 but I am unable to install Windows 10 in the above environment due to the M1 Chip (ARM based, not x86).If you partition the Primary 1TB SSD, the problem persists because the partition is still recognised internally as “One Single Hard Drive”.If you have a Second “Physical” Hard Drive, SQL Server 2019 installs properly on the second drive (this option is not available to me).If the Primary Hard Drive does not exceed 980GB, SQL Server 2019 installs properly (this option is not available to me).In the above environment, my observations so far after reading many threads: Windows 11 Pro (downloaded the ARM based not x86, which is the right version for my Macbook Pro M1).macOS Monterey 12.1 (updated as of 10 January 2022).Total Number of Cores = 10 (8 performance and 2 efficiency).MacBook Pro 16” / 1TB SSD / Apple M1 Max Chip / 64GB RAM / 2021 Model.We are unable to install SQL Server 2019 (Express or Standard) in the following scenario: ![]() However, we are faced with this huge problem as follows: ![]() We have done SQL Server 2019 installations for many customers globally. *Note that the Win11 Preview that I have downloaded from Microsoft site is ARM based not x86 which is the right version for my Macbook Pro M1. What is your recommendation? Is this even supported on M1 Macbook Pros? I am thinking may be it is not well tested under this environment. Note that other features like SSIS Reprots, Browser etc does gets installed and works fine but not the SQL Server. I have spend 3 days on ths now and I would really like to make it work in Parallels, since the new Macbook Pro is really capable and runs everything like a breeze, but SQL Server is not working. ![]() If I run SQL from command prompt, I get my SQL Server may be corrupt, re-install.Tried SQL Server 2019 Developer version, 2017 Express Version, 2017 Developer version and and 2016 with SP2 but all had one issue or another.Had to manually add start parameters, played with permission, wont work/wont start.The installation gives some kind of error but then it completes.So I am pretty fluent with SQL Server and have installed it on many machines and it works, but lately I have been trying to install SQL Server in Parallels on my new 2021 Macbook Pro 16" model and it would not work for one reason or another.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |