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 –
- docker pull microsoft/mssql-server-linux
- 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