#2012 docker sql server on mac install#

Let’s do a quick breakdown of what we are doing in the docker run script above:

Then you will run the following code at the command line: docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=thisisastrongpassw0rd!' -p 1434:1433 -name sql2019u -v /Users/josephineb/Documents/Docker/sql2019u:/var/opt/mssql/data -v /Users/josephineb/Documents/Docker/sql2019u/secrets:/var/opt/mssql/secrets -d /mssql/server:2019-latest I just set up a folder structure here: /Users/josephineb/Documents/Docker/sql2019u because I’m using the latest SQL Server 2019 version on Ubuntu, but you can name your folder whatever you want. Let’s set up this SQL Server container!įirst things first, set up a folder on your local machine that you will map to your container. You will be using Terminal on Mac instead. You won’t need to use Docker from this menu. Once Docker is installed, you will see this icon in the top left of your Mac desktop screen: Installation and instructions are included on this page:

#2012 docker sql server on mac install#

So, you will need to install Docker on your local machine and have it set to use Linux containers.

This article assumes you have a working knowledge of containerization and SQL Server, but may provide enough detail to get you up and running with very little knowledge on either. There’s a lot of talk about attaching databases after you recreate your Docker container, but I found that you just have to mount the volumes that SQL Server uses to hold the system and user databases to a folder on your local drive, and if you remove the container you can recreate it and mount the same local drives without losing any data or settings. This is a super simple way to retain the data and settings that you create and change on your SQL Server Docker instance.