#Install sql server on mac with docker how to
#Install sql server on mac with docker install
#Install sql server on mac with docker password
#Install sql server on mac with docker windows

But then I’m again dependent on a Windows VM, which also needs periodically updates, and it would be also a huge overhead to deploy a whole Windows VM just for SQL Server Management Studio… But how do we access SQL Server? Of course, I can start up a Windows VM, and use SQL Server Management Studio to access SQL Server. We have now 2019 up and running in a Docker Container. This just means that you can close your Terminal, and your Docker Container is still running in the background.Īfter you have executed that Docker command, your Docker Container is up and running.

And with the -d option we specify the Docker Image that we have pulled previously, and that you want to run the Docker Container detached from the Terminal.

With the –name option we assign a custom name to our Docker Container.

If you have multiple SQL Server Containers, you can also bind them to different ports on your host machine to access them independently from each other.

Therefore I can directly access the exposed SQL Server Container through the IP address of my Mac on the network.

In my case I bind the default SQL Server port of 1433 within the Container to the port 1433 on my Mac. The port on the left side of the colon is the port on the host machine, and the port on the right side of the colon is the port in the Container.

With the -p option we bind a port on our host machine (in my case on the Mac) to a port in the Container.

#Install sql server on mac with docker password

With the SA_PASSWORD environment variable we set the password for the SA login.

In our case we have to accept the EULA to be able to use SQL Server.

With the -e option you set an environment variable, on which SQL Server is dependent on.

Let’s run our Docker Image with the docker run command:ĭocker run -e ‘ACCEPT_EULA=Y’ -e ‘SA_PASSWORD=passw0rd1!’ -p 1433:1433 –name sql2019_ctp2 -d /mssql/server:vNext-CTP2.0-ubuntuĪs you can see from the command line, you have to pass in a lot of different parameters.

And that creates the actual Docker Container, which is finally the exectuable that you are executing. In Docker you can “install” an image by running it. Therefore we also have to “install” the pulled Docker Image.

#Install sql server on mac with docker install

You can think about a Docker Image like an ISO file: it’s just an image, and you can’t run it directly, because you have to install it. When you have pulled the image, you can see it with the docker images command in your Terminal: In my case I have decided to try out the latest CTP version of SQL Server 2019:ĭocker pull /mssql/server:2019-CTP2.1-ubuntu

#Install sql server on mac with docker how to

I don’t want to go into the details how to install Docker itself, because the necessary steps are very well documented.īefore you can create a Docker Container for SQL Server, you have to pull the correct Docker Image from the Docker Registry. Installing SQL Server in a Docker Containerīefore you can install SQL Server in a Docker Container on the Mac, you have to install and configure of course Docker itself. In this blog posting I want to show you how you can do the same and run SQL Server directly on your Mac in a Docker container. Because now I can run SQL Server 2017+ directly on my Mac and I even don’t really need a Windows VM anymore. Therefore running natively on MacOS was not a big deal for me, and for the last resort I always have a Windows VM which runs in VMware Fusion on my Mac.īut since the introduction of the Container concept through Docker and the possibility to run SQL Server directly in a Container, my life was changing even better.

How can I be that stupid to work on MacOS when I’m dependent on SQL Server? In my case it wasn’t that terrible, because my main work is about content creation (writing blog postings, articles, presentations, training videos) and very often I was only connecting through a RDP connection to a remote SQL Server. Years ago when I switched from Windows to Mac, people have told me regularily that I’m crazy.