SQL Server database on a MacBook Pro M1

Dear,

As you can see in the next images, I can install MSSQL Server 2019 in Windows 10 ARM.

1- Download the image of windows 10 ARM in the link https://www.microsoft.com/en-us/software-download/windowsinsiderpreviewARM64

2- Download MSSQL server DEV edition https://www.microsoft.com/es-es/sql-server/sql-server-downloads

3- Download Parallels for ARM https://b2b.parallels.com/apple-silicon/?gclid=CjwKCAjw3pWDBhB3EiwAV1c5rPN8G4gJVu-PUFd_xAE1wZpagTnkyK4spvqQDc-vFflJKFoR4vu-9hoCcGUQAvD_BwE

4- When Windows 10 ARM is installed is necessary to install all updates of SO

5- After installing all updates open the MSSQL Server installer and chose "Basic".

6- All packages going to be download.

7- And after the installation finished an error message appears, close everithing.

8- Go to the next path to open the installer.

9- for the ARM architecture, you must to select only the next option

10- I recommend the next name for the instance for MSSQL

11- Keep manual all the service

12- Select Mixed mode

13- And the follow the install

14- And the service is installed.

15- And install SQL Server Management tools.

Hi poligono,

I installed SQL Server successfully, but the SQL Server Network Configuration in the Sql Server Configuration Manager is missing, so I can not connect to the databases from remote. I tried with both the Developer and Express editions.

Any suggestions?

Thanks

John

Hi, can you please guide me how to install sql express server on M1 macbook?

I have tried however it shows as failed for no 32 bit version etc . Attached the screenshot

poligono1191 wrote:

Why not ?

Read my initial post above. You are using a test/beta environment that is not available to everyone. The original poster indicated that he needs this for his business. It is never a good idea to use test/beta configurations in a production environment.

Yes, you are right, windows is a beta, but MSSQL and parallels not, yesterday parallels release the stable version for ARM, but I was answering to other user the way to install MSSQL in parallels for M1. For the original poster can use this way or use a container azure and as you say, never is a good idea to use test/beta configuration in a production environment.

Dear,

To connect remotely you can configure from the MSSQL Manager in the server properties.

With this version, the configuration manager disappears, but if you access the services of windows you can activate the service of MSSQL.

I've followed instructions by poligono1191, but getting error at the very end of installation:

----

Error installing SQL Server Database Engine Services Instance Features

Unknown error (0xe0000235)

Error code: 0x80004005

Visithttps://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0xF57C3D6F%400xDC80C325&EvtType=0xF57C3D6F%400xDC80C325 to get help on troubleshooting.

---

And this is from setup log file:

06/19/2021 10:28:00.588 ======================================================================

06/19/2021 10:28:00.588 Setup launched

06/19/2021 10:28:00.588 Attempting to determine media source

06/19/2021 10:28:00.588 Media source: C:\SQL2019\Developer_ENU\

06/19/2021 10:28:00.588 Attempt to determine media layout based on file 'C:\SQL2019\Developer_ENU\mediainfo.xml'.

06/19/2021 10:28:00.588 Media layout is detected as: Full

06/19/2021 10:28:00.588 Not a slip stream media, so continuing to run setup.exe from media.

06/19/2021 10:28:00.588 /? or /HELP or /ACTION=HELP specified: false

06/19/2021 10:28:00.588 Help display: false

06/19/2021 10:28:00.588 .Net version 4.6 is installed

06/19/2021 10:28:00.588 Current running setup.exe full path: C:\SQL2019\Developer_ENU\SETUP.EXE

06/19/2021 10:28:00.588 Media setup.exe file version detected: 2019.150.2000.5

06/19/2021 10:28:00.588 Locally installed setup.exe full path: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\SQL2019\setup.exe

06/19/2021 10:28:00.588 Local setup.exe file version detected: 2019.150.4013.40

06/19/2021 10:28:00.588 Local setup.exe version 2019.150.4013.40 is equal or greater than media version 2019.150.2000.5, so re-launching setup.exe from local

06/19/2021 10:28:00.588 Media source: C:\SQL2019\Developer_ENU\

06/19/2021 10:28:00.588 Install media path: C:\SQL2019\Developer_ENU\x64\setup\

06/19/2021 10:28:00.588 Media layout: Full

06/19/2021 10:28:00.604 Attempting to get execution timestamp

06/19/2021 10:28:00.604 Timestamp: 20210619_102800

06/19/2021 10:28:00.604 Attempting to launch local setup.exe

06/19/2021 10:28:00.604 Attempting to launch process C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\SQL2019\setup.exe

06/19/2021 10:37:23.384 Process returned exit code: 0x80004005

06/19/2021 10:37:23.384 Local setup.exe returned exit code: 0x80004005

06/19/2021 10:37:23.384 Setup closed with exit code: 0x84C40013

06/19/2021 10:37:23.384 ======================================================================

It gives me hope that it's possible if someone else succeeded, but don't know why it works for some and not the others..

OK, managed to install! Exactly the same steps, but I've paused Windows 10 Insider Preview 10.0.21390.025 (co_release) before running setup.exe for the second time. I've also ran setup.exe as administrator, not sure if important or not.

in my case, I installed windows 10 ARM on Parallels desktop, then I installed SQL Server express 2014 32 Bits and its work, as you can see in the next image.

Hi, poligono.

I followed your instructions, but at step 14, it said status failed.

something to do with no file msoldbsql.msi

any suggestions?

Hey, poligono.

I followed your instructions, but at step 14, it said status failed.

something to do with no file msoldbsql.msi

any suggestions?

Can you tell me what’s wrong?

Hi, did you or anyone solved this ??? I need help

Let me know the best method to RUN SQL Server on my Mac M1

@poligono1191 Can you teach me how to install it? Thank you