SQL + Azure Data Studio Installation guideline for Intel Mac

Download and Install Docker for Mac

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

Step 2: Click on Download.

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.

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:

Make sure to change this part of the command SA_PASSWORD=reallyStrongPwd123' to a strong password so you don’t face any errors

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

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.

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.