This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I know there's been questions in the past when the ARM based MacBooks launched but now that Microsoft is shipping more ARM devices with the new Surface Pro and Surface Laptop is there any updated way to install and run MSSQL? Is Docker still the best approach on ARM based devices?
In the SQL Server docs there's this https://learn.microsoft.com/en-us/sql/linux/tutorial-restore-backup-in-sql-server-container?view=sql-server-ver16&tabs=cli. But it would be nice if there was official 'Windows on ARM' documentation for getting setup. (If there is I haven't found it but would be grateful if someone shared that link)
SQL Server does not support ARM, so yes, Docker may be the way to do. I say "may", because I have no idea if it actually works.
Okay good to know, I'll give it 10 minutes of trying otherwise I'll just default to a different x86 machine for this application. Thank you!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 6%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
thus, why if you try to connect to MYSQL database using odbc mysql connector with Access the connection run? Surface Laptop with ARm Snapdragon X Elite.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
you are confusing the driver with hosting the database. MySql for windows server only support windows intel. The Mac versions of the server supports both intel and arm.
note: it should be able to connect to SqlServer hosted on a different machine
I might be missing something but how would connecting to MySQL help with MSSQL? I'm not a database expert but I don't see the connection for getting MSSQL running on arm64.
Miguel's Corbillo's comment was entirely off-topic. Some people have a difficulty to keep MS SQL Server and MySQL apart.
there is no official SQLServer arm64 support.
Docker on Mac arm systems has setting:
[] Use Rosetta for x86_64/amd64 emulation on Apple Silicon to enable running x86
which allows running x86_64/amd64 containers. while originally experimental, it has been added to the base package. this feature has been widely used to run SQLServer docker containers on apple silicon.
note: I don't believe anyone has created this feature for windows arm. docker for windows arm is fairly new.
I think I was hoping that since Apple Silicon has been out for a while that there was a solid arm64 solution.
Thanks for the info!
Actually the sql team dropped support of the arm version of Sqlserver (azure sql edge). I still use the docker version, but it’s no longer available.
I got a tip from an MVP colleague that the Prism emulation layer is the way to to: https://learn.microsoft.com/en-us/windows/arm/apps-on-arm-x86-emulation.
He thinks that you need Windows 11 24H2 for this to work, but I guess the brand-new surface comes with this version.
It sounds like Prism should run automatically but still failed to install.
I tried with the downloaded installer this time; first attempt was through winget. And I checked I do have Windows 11 24H2. Maybe this is still being worked on? I checked to see if there was something along the lines of 'Run with Prism' available on the file, but I didn't see any. I'll have to keep an eye on the Prism space and see if future updates allow for this to work. I'd be okay with whatever performance hit I'd take by running in that emulation layer but for now I might have to work on this one application on my old x86 machine.
Thanks again for your help!
Thanks for your help @Erland Sommarskog , it seems that Prism (as of now) doesn't support emulation for drivers or kernel components so that's probably why it's failing on the install and not using the emulation layer for it. Maybe in the future this changes as WoA (hopefully) continues and grows.