Fronix/sql-server-m1-mac.md

## sql-server-m1-mac.md

      
    Raw
  

              sql-server-m1-mac.md
            
          
    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.