You should be connected to the localhost server now. Connect to SQL Server in Azure Data Studio Unzip the downloaded file and move the file to the Applications folder. You have successfully configured an OpenLink ODBC Driver for SQL Server on macOS using the very same visual configuration pattern available to Windows users i.e., you haven’t had to.
Here’s a link you can download Azure Data Studio from: Download and install Azure Data Studio You can install Azure Data Studio install to have GUI for the SQL Server. It’s way easier to see your data in tables visually rather than in terminal window. You should be in the mssql window now and you can run queries and perform database operations now. Run the following command to install the sql-cli command: Use a stronger password if you get an error. mssql/server:2019-latest: Docker image to use
p 1433:1433: maps the local port 1433 to port 1433 on the container e ‘SA_PASSWORD=macSQL123’: set the database password e ‘ACCEPT_EULA=Y’: Yes(Y) to agree with the EULA (End User Licence Agreement) –name sql_server_yc: name the container, OPTIONAL d: launches the Docker container in daemon mode (runs the command in the background), OPTIONAL The following command will launch the Docker image we downloaded:ĭocker run -d -name sql_server_yc -e 'ACCEPT_EULA=Y' -e 'YC_PASSWORD=macSQL123' -p 1433:1433 /mssql/server:2019-latest Sudo docker pull /mssql/server:2019-latest
The following command will download SQL server 2019 for Linux Docker image.
You should be instructed by the Docker installation guide. dmg file and drag and drop the Docker to the Applications folder. Once you download it, it’s easy to install. Here’s a link to download the latest version of Docker for Mac: Install Docker Desktop on Mac You’re basically gonna create an instance of the server on the Docker. To have the Microsoft SQL server on your MacOS, you need to have Docker installed first.