Installing Microsoft SQL Server on Mac OS using Docker

Sunday 19 April 2020, by Jayan Karmacharya

You can install SQL Server on to a Mac using Docker. You will get not full feature of SQL Server Management studio though. We highly recommend you to use Windows OS for SQL Server if possible. If you don’t have that option then please follow the instruction as shown below.

Install docker https://www.docker.com/docker-mac

From Terminal run command –

  1. docker pull microsoft/mssql-server-linux
  2. docker run -d --name MySQLServer -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Password123@jkl#' -p 1433:1433 microsoft/mssql-server-linux
  • Name can be any custom name of your choice
  • Password can be of your choice provided it is the combination of uppercase, lowercase, numbers and special characters

Download azure data studio from https://docs.microsoft.com/en-us/sql/azure-data-studio/download?view=sql-server-2017

Open azure data studio and provide connection parameters:
host: localhost
authentication type: SQL Login
user: sa
password: Password123@jkl#
Database : Default
Server Group: Default

Click on connect


About The Author

This article was posted by .

Join the discussion by adding your comments below: