How to use SQL server on M1 Mac

Prerequisites

Docker & docker-compose
Brew

Setup Colima VM

brew install colima

Add AMD arch VM to Colima

Important that you use --arch amd or it wont work

colima start --profile amd --arch amd

Wait for VM to start

Verify VM is running

➜  ~ colima status amd
INFO[0000] colima [profile=amd] is running              
INFO[0000] runtime: docker                              
INFO[0000] arch: x86_64

Test

docker-compose.yml

services:
  sqltest:
    container_name: sqltest
    image: mcr.microsoft.com/mssql/server
    ports:
      - '1433:1433'
    environment:
      SA_PASSWORD: 'sUp3Rs3cR3tp@zzw0rD'
      ACCEPT_EULA: 'Y'
      MSSQL_PID: 'Express'

Save somewhere on disk

Navigate to docker-compose.yml file and run

docker-compose up -d
docker logs sqltest

Logs should look normal and no exit codes :)

IMPORTANT!

Docker GUI wont work anymore, you will have to manage docker using docker CLI.

sjkp/sql-server-m1-mac.md