How to run MS SQL server on Mac ?

You can not install MS SQL server directly on Mac like on other machine. You need to install Docker first:

Step 1: Download the Docker form Docker Hub.

Step 2: Increase Docker Memory. Go to Docker -> Preference. In Advance Increase memory to 4 GB.

Step 3: Open a Terminal window, and download the latest SQL Server for Linux Docker image using below command

docker pull microsoft/mssql-server-linux:2017-latest

Step 4: Launch the instance of Docker Image using below command

docker run -d --name Homer -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=myPassw0rd' -p 1433:1433 microsoft/mssql-server-linux

Now use SQL CLI or any other tool to execute your commands. To connect use username sa and password given in above command.