How to install Microsoft SQL server management on MacOS M3

Question

How to install Microsoft SQL server management on MacOS M3.

Hello, for two days I’m trying to get Microsoft SQL management studio on MacBook with M3 processor. I was trying to do it with parellels, but it didn’t work. Is there any possibilities to get mssql on Mac excluding azure? I need Management studio for school.

Answer 1

Hi @jack281

As per Microsoft document, https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

SSMS is available only as a 32-bit application for Windows. If you need a tool that runs on operating systems other than Windows, we recommend Azure Data Studio. Azure Data Studio is a cross-platform tool that runs on macOS, Linux, and Windows. For details, see Azure Data Studio.

Thank you!

Answer 2

For arm azure data studio is your only option

https://learn.microsoft.com/en-us/azure-data-studio/download-azure-data-studio?view=sql-server-ver16&tabs=win-install%2Cwin-user-install%2Credhat-install%2Cwindows-uninstall%2Credhat-uninstall

as you have a m3 you could try hosting intel windows with

https://mac.getutm.app

it will be slower than parallels and not as integrated and more complex to setup.