Installation guideline for SQL + Azure Data Studio (macOS)

Welcome to our installation guide for SQL Server and Azure Data Studio – essential tools in database management. SQL Server, a Microsoft-developed relational database system, is widely used for data storage. Azure Data Studio offers a modern interface for efficient database development.

This guide will help you install SQL and Azure Data Studio.

1 Installation Video
2 Download Docker
3 Install Azure SQL Edge
4 Download Azure Data Studio
5 Connect to SQL Server

Installation Video

Download Docker

Step 1: Download Docker from this link.

Step 2: Docker.dmg will be downloaded, you may find it in your Downloads folder. Click on it.

Step 3: Drag and drop to your Applications folder.

Step 4: Launch Docker by clicking on its icon.

Step 5: Go to Settings.

Install Azure SQL Edge

Step 1: Open Terminal and run the command below.

docker pull mcr.microsoft.com/azure-sql-edge

Result:

Step 2: Next run the command below. You will be prompted for your device’s password which will be invisible, then click enter.

sudo docker run --cap-add SYS_PTRACE -e 'ACCEPT_EULA=1' -e 'MSSQL_SA_PASSWORD=bigStrongPwd' -p 1433:1433 --name sqledge -d mcr.microsoft.com/azure-sql-edge

Replace “bigStrongPwd” with a strong password of your choice.

Result:

Download Azure Data Studio

Step 1: Go to Azure Data Studio download page.

Step 2: Scroll down to find this table. Click on Apple silicon .

Step 3: Unzip the .zip file downloaded and double click on it to launch Azure Data Studio.

Connect to SQL Server

Step 1: Click on Create a connection.

Step 2: Fill in the Connection Details as shown below. For Username and Password, create your own. Then click Connect.

Connection type	Microsoft SQL Server
Input type	Parameters
Server	localhost
Authentication Type	SQL Login
User name	your_chosen_username
Password	reallyStrongPwd123
Database	<default>
Encrypt	Mandatory (True)
Trust Server certificate	True
Server Group	<default>

Result: You are now connected to SQL Server.