DEV Community

loading...

Installing Microsoft SQL Server on your Mac with docker

StuartCreed
Full Stack Web Developer
・1 min read

https://www.londonacademyofit.co.uk/blog/installing-sql-server-on-mac-using-docker
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#

Or use tablePlus:
image

Discussion (0)