Quick Start - dbafromthecold/SqlServerAndContainersGuide GitHub Wiki

This guide will get you up and running with SQL Server in a Docker container in a couple of minutes. For a breakdown of what each line of code does check out the Quick Start Explained page.

To get a container up and running quickly, you can run: -

docker container run -d -p 1433:1433 `
--env ACCEPT_EULA=Y `
--env MSSQL_SA_PASSWORD=Testing1122 `
--name sqlcontainer1 `
mcr.microsoft.com/mssql/server:2019-latest

/images/1.QuickStart/1.docker_container_run.png

Execute that, the image will be pulled down for you. You can check this by running: -

docker image ls

/images/1.QuickStart/2.docker_images.png

And you can then confirm that your container is running: -

docker container ls -a

/images/1.QuickStart/3.docker_container_ls.png

If your container is up and running you will be able to connect to it in SSMS or ADS via servername localhost and password Testing1122

/images/1.QuickStart/4.connected_in_ssms.png

And that's a real quick start into SQL Server running in a Docker container. Check out the rest of the wiki for more information!