Unable to install SQL Server 2019 on M1 Mac 1TB SSD with Parallels and Windows 11

We have

done SQL Server 2019 installations for many customers globally. However, we are

faced with this huge problem as follows:

We are

unable to install SQL Server 2019 (Express or Standard) in the following

scenario:

- MacBook Pro 16” / 1TB SSD / Apple M1 Max Chip / 64GB RAM / 2021

Model

- Total Number of Cores = 10 (8 performance and 2 efficiency)

- System Firmware Version = 7429.61.2

- OS Loader Version = 7429.61.2

- macOS Monterey 12.1 (updated as of 10 January 2022)

- Parallels Ver 17

- Windows 11 Pro (downloaded the ARM based not x86, which is the right

version for my Macbook Pro M1)

In the above environment, my observations so far after reading many

threads:

1.              

If the Primary Hard Drive does not exceed 980GB, SQL Server 2019

installs properly (this option is not available to me)

2.              

If you have a Second “Physical” Hard Drive, SQL Server 2019 installs

properly on the second drive (this option is not available to me)

3.              

If you partition the Primary 1TB SSD, the problem persists because the

partition is still recognised internally as “One Single Hard Drive”

4.              

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)

5.              

Even if I sign up for “Windows Insider Program”, Windows 10 ISO File

is not available for the above environment

6.              

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

7.              

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

8.              

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

9.              

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

I followed the following steps as

recommended by the Gurus (to Fix “Sector Size)

1.    

Change Registry (run as Administrator) as follows:

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

·      

New

·      

Multi-String value

·      

ForcedPhysicalSectorSizeInBytes

·      

4095

2.    

Run the following on CMD Prompt (run as Administrator)

"HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device"

/v "ForcedPhysicalSectorSizeInBytes" /t   REG_MULTI_SZ /d "* 4095" /f

3.    

Verify as follows on CMD Prompt (run as Administrator):

REG QUERY

"HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device"

/v "ForcedPhysicalSectorSizeInBytes"

4.    

Run the following on PowerShell (run as Administrator)

New-ItemProperty

-Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device"

-Name  

"ForcedPhysicalSectorSizeInBytes" -PropertyType MultiString

-Force -Value "* 4095"

5.    

Verify the following on PowerShell (run as Administrator)

Get-ItemProperty

-Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device"

-Name  

"ForcedPhysicalSectorSizeInBytes"

6.    

Restart Windows 11 and Install SQL Server 2019

My Results after doing the above

SQL Server Standard

2019 Installation Results:

Installation

Failed for

1.    

Data Quality Services

2.    

Full-Text and Semantic Extractions for Search

3.    

Python

4.    

R

5.    

Machine Learning Services and Language Extensions

6.    

Database Engine Services

7.    

SQL Server Replication

—————————————————————

HELP REQUIRED!

I really

need your help in getting a resolution for the above. It is really strange that

both SQL Server 2019 and Windows 11 are Microsoft products and they seem to

have such a huge glitch.

Thank you

in advance, everyone!

—————————————————————

We already have Done installation SQL 2019 Standard edition on our system but our new MacBook Pro 16 we are not able to install SQL 2019 Standard edition -----

- MacBook Pro 16” / 1TB SSD / Apple M1 Max

Chip / 64GB RAM / 2021 Model

- Total Number of Cores = 10 (8

performance and 2 efficiency)

- System Firmware Version = 7429.61.2

- OS Loader Version = 7429.61.2

- macOS Monterey 12.1 (updated as of 10

January 2022)

- Parallels Ver 17

- Windows 11 Pro (downloaded the ARM

based not x86, which is the right version for my Macbook Pro M1)

In the above environment, my observations

so far after reading many threads:

If the Primary Hard Drive does not exceed 980GB, SQL Server 2019

installs properly (this option is not available to me)

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 you partition the Primary 1TB SSD, the problem persists because the

partition is still recognized internally as “One Single Hard Drive”

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)

Even if I sign up for “Windows Insider Program”, Windows 10 ISO File

is not available for the above environment

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

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

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

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

I followed the following steps as

recommended by the Gurus (to Fix “Sector Size)

Change Registry (run as Administrator) as follows:

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

       New

       Multi-String value

       ForcedPhysicalSectorSizeInBytes

       4095

Run the following on CMD Prompt (run as Administrator)

"HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device"

/v "ForcedPhysicalSectorSizeInBytes" /t   REG_MULTI_SZ /d "* 4095" /f

Verify as follows on CMD Prompt (run as Administrator):

REG QUERY "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device"

/v "ForcedPhysicalSectorSizeInBytes"

Run the following on PowerShell (run as Administrator)

New-ItemProperty

Path

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

PropertyType MultiString -Force -Value "* 4095"

Verify the following on PowerShell (run as Administrator)

Get-ItemProperty

Path

"HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device"

Name   "ForcedPhysicalSectorSizeInBytes"

Restart Windows 11 and Install SQL Server 2019.

HELP REQUIRED!

Thank you

Windows does not run on the M1 chip Macs. If you get the ARM version of Windows running it is a pre-release version and should only be used in a non-production environment. We can not , according to the TOU of these communities, discuss beta (pre-release) versions of software.

Everything I've ever seen says you need to use Azure SQL Edge to do the install.

Sir Please help to solve this issue ???????

FACT_ERP_Solutions wrote:

What is your expert opinion on this?

Windows does not run on a M1 Mac.

If there is some other issue with SQL Server take up that issue with Microsoft.

sudipta212 wrote:

Sir Please help to solve this issue ???????

It can't be solved. The software has requirements that can not be achieved with the M1 chip Mac.