[Mac]透過Docker運行MSSQL

1. 到官網下載mac安裝包

2. 開啟Docker軟體，登入後確認記憶體是否有開到4GB以上

3. Termial 下載MSSQL映像檔

sudo docker pull mcr.microsoft.com/mssql/server:2022-latest

4. 啟動Linux container image

sudo docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=<YourStrong@Passw0rd>" \
   -p 1433:1433 --name sql1 --hostname sql1 \
   -d \
   mcr.microsoft.com/mssql/server:2022-latest

完成後會在continers欄位看到”sql1”

5. 確認安裝成功

sudo docker ps -a

6. 更改密碼

sudo docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd \
-S localhost -U SA \
 -P "$(read -sp "Enter current SA password: "; echo "${REPLY}")" \
 -Q "ALTER LOGIN SA WITH PASSWORD=\"$(read -sp "Enter new SA password: "; echo "${REPLY}")\""

7. 連到SQL Server

sudo docker exec -it sql1 "bash"

References