SQL + Azure Data Studio Installation guideline for Intel Mac

Azure Data Studio is a lightweight, cross-platform data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and CosmosDB.

This guide will help you install Microsoft SQL Server 2022 with SQL Server Management Studio (SSMS).

Installation Video

Download and Install Docker for Mac

Step 1: Download Docker for Mac, Go to Download Docker.

Step 2: Click on Download.

Install Docker

Step 1: Go to Download folder in finder. Run Docker setup file.

Step 2: Move the Docker to the Application folder.

Step 3: Wait for the installation to be done.

Step 4: Choose Use recommended settings (require password) option, then click Finish.

Step 5: Enter your “password”, then click OK.

Step 6: Login to Docker or signup if you don’t have an account.

Result: Docker will be running successfully.

Download SQL

Step 1: Open a Terminal window and run the following command.

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

Step 2: Run the following command to launch an instance of the Docker image you just downloaded:

docker run -d --name sql_server_demo -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=reallyStrongPwd123' -p 1433:1433 mcr.microsoft.com/mssql/server:2019-latest

Result: A new image will appear in the container of Docker

Download Azure Database

Step 1: Download Azure Data Studio for macOS

Step 2: To expand the contents of the .zip file, double-click it.

Step 3: To make Azure Data Studio available in Launchpad, drag the Azure Data Studio.app file to the Applications folder.

Result: Azure Data Studio is installed successfully.

Connect Azure Data Studio to SQL

Step 1: Open Azure Data Studio

Step 2: Create a new Connection.

Step 3: Enter server name “localhost”, enter username “sa” and the password you created earlier while installing SQL, then click Connect

Step 4: Click Enable Trust server certificate.

Result: You have connected to your local SQL database successfully.