It remains docked at my desk where it happily helps me to go about my daily business.

Of course, these days Im maintaining social distancing so getting away from my desk to work elsewhere means working from my kitchen table for a change of scenery.

Docker Sql Server Install SQL Server

Yes, I could install SQL Server on the OS but its my personal machine and Im not that familiar with SQL on Linux (yet).

Docker, however, it a great solution to allow me to run SQL Server containers on my Macbook without having to set up anything.

The images are what define the container which then in turn runs the application, which in our case is SQL Server.

Once you have it installed, youll have a dashboard like the one shown below.

Docker Sql Server Download If Needed

I got my image from Docker Hub, a library of container images that you can browse and subsequently download if needed.

Searching for SQL Server images, we can see that Microsoft has their own registry that has a few available container images.

If you scroll further down the page, you can browse the full is list of available tags that can be used to download an image.

To obtain the image, you can issue a pull command from within a terminal session.

Youll notice that Docker Hub provides you with the command in the above image.

As shown below, you can see that I have three images available.

Since SQL Server has already been installed within the container, it must now be configured for it to successfully start.

Essentially, we need to tell Docker to run the image and pass in some parameters.

Here we are accepting the end user license agreement (EULA) as well as supplying a SA password (its required).

The value on the left side of the colon is the port on the host and the value on the right side is the port within the container.

In this example, both sides will be listening on port 1433, which is the default port for SQL.

In this example I want to run the 2019-latest image pulled from Microsoft.com.

ACCEPTEULAY -e SAPASSWORDyourStrong()Password -p 1433:1433 -d mcr.microsoft.commssqlserver:2019-latest Running this command, if all is correct, will return a GUID looking value.

We can see that the version is 2019 CU4 which is the latest release for SQL Server 2019.

For example, if I need to see what parameters are available for the run command, I would type in docker run help.

The output would display all of the available parameters that you can supply with the run command.

Often times I just need an instance to test a feature or try to figure out how something works.

All in all, this process takes about 5-10 minutes to finish and it significantly faster than standing up a VM.

Docker For Mac Sql Server