Starting with SQL Server 2017, Microsoft announced you can run SQL in Docker containers. This is great news for DBA’s because we tend to run multiple installations of SQL Server locally and with Docker we can spin up (or remove) a SQL instance fairly quickly.
I’m not going to go into what Docker is because there’s an entire website that goes into much more detail than I ever could. This post is going to focus on a simple SQL installation on Windows 10 using Docker. Let ‘s gooooooo!
First, let’s download and install the latest version of Docker. To find the latest version, open an internet browser and navigate to https://docs.docker.com/docker-for-windows/install/. From here, click “Download from Docker Hub”
You will need to create a docker ID and password if you don’t have one. Once you have this info let’s login.
Next, let’s click “Get started with Docker Desktop” from the home page and “Download Docker Desktop for Windows”
After the download is complete, go ahead and start the install. On the Configuration screen, I’m going to Use Windows containers instead of Linux. Click OK.
Docker Desktop is installing:
After installation succeeds, you must log out so make sure to save everything!
Upon logging back in, you will be greeted with this message, Hit OK and reboot.
After reboot, let’s open Powershell (as administrator) and issue the following statement. This will show you that Docker is installed properly and it will give you the version we are running.
Next, let’s do a search for a SQL Server image. Back in Docker Hub, in the search box, let’s type SQL Server and click on Microsoft SQL Server:
This page will give you all sorts of valuable information.
You can also use the following PowerShell statement to pull SQL Server images:
Docker search Microsoft
Again, from Powershell, let’s download the Microsoft SQL Server Developer Edition images. To do this use the following:
Docker pull microsoft/mssql-server-windows-developer
This will take a few minutes so grab some coffee…..or a beer.
Once the download is complete you can run the following statement to see the images downloaded:
OK, we have Docker installed and our SQL Server image downloaded. Now the fun part….install SQL Server! In PowerShell, let’s run the following:
Docker run –name DockerSQL -d -p 14331:1433 -e sa_password= St0ngP@SSw0rd! -e ACCEPT_EULA=Y microsoft/mssql-server-windows-developer
- –name – this is the name of the container you are creating
- -d – Runs the container in the background otherwise the container will take over your cmd when it starts
- – p port:port – Maps a TCP port on the host environment (first value) with a TCP port in the container (second value). In this example, SQL Server is listening on TCP 14331 in the container and this is exposed to the port, 1433, on the host. I’m using 14331 because I’ll create multiple containers and each container needs a different port number.
- -e – Creates environment variables under the container execution runtime, for example, sa password and End User License Agreement (EULA)
- sa_password – Create sa password for SQL instance (Hint, don’t use a $)
- ACCEPT_EULA – Yes
It will take a few minutes to finish the install, but it’s much shorter than a regular SQL install. Once finished, run the following to get the IP address of the container (make sure to use your container name after docker inspect):
$Container_1 = docker inspect DockerSQL |
select -ExpandProperty SyncRoot |
select -expand netWorkSettings |
select -ExpandProperty Networks |
Select -ExpandProperty nat |
As you can see, the IP for my container is 172.31.29.174. If I open SQL Server Management Studio and connect to this IP using the sa account and password I created I can connect successfully:
If you have any issues connecting try using the following docker statement to view the logs:
Docker container logs –details DockerSQL
To remove the container, simply stop the container
Docker stop DockerSQL
Docker rm DockerSQL