Deploy and Connect to Azure SQL Edge on Mac M1 Chip

 

Problem:

SQL Server does not seem to be available for the Mac M1 chip.

Solution:

Instead, we can utilize Azure SQL Edge.

1. Deploy an instance for Azure SQL Edge using a Docker image

1.1. From a terminal, run this.

docker run --cap-add SYS_PTRACE -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=YourPassword' -p 1433:1433 --name azuresqledge -d mcr.microsoft.com/azure-sql-edge

note: Change the password from "YourPassword" to yours.

2. Connect to the Azure SQL Edge instance using Azure Data Studio

2.1. Click Create a connection

2.2. Input the info below.

server: localhost

user name: sa

password: your password

ref:

- https://hub.docker.com/_/microsoft-azure-sql-edge

- https://medium.com/geekculture/docker-express-running-a-local-sql-server-on-your-m1-mac-8bbc22c49dc9

- https://medium.com/geekculture/how-to-install-sql-server-in-mac-m1-41121e110214