...
On macOS environment, you will need to run Microsoft SQL Server in a Docker container and interface with the database using compatible Database client, such as Azure Data Studio.
Installation guides:
Intel - https://database.guide/how-to-install-sql-server-on-a-mac/
Arm64 (M1, M2) - https://database.guide/how-to-install-sql-server-on-an-m1-mac-arm64/
Important: Remember to set a strong password for the Server Administrator (SA) account or the SQL Server will not run!
...
Preface
To setup SQL Server in your workstation, you need to have at least the core function installed. The SQL Server installer will install the back-end service(s) that handle the database, while SQL Server Management Studio (SSMS) is responsible for providing the interface to access and interact with the database. Everything you do will go through a database manager before the changes are reflected in the database.
...