This article was written in 2019. Versions, tools and recommendations may have changed since then. Newer posts are collected under Docker.
For some time now, Microsoft has been providing various MSSQL Server versions for Docker - for Linux and for Windows. This means that spending a few hours to install MSSQL Server on your own PC is a thing of the past and is now available with Docker in a few moments.
Docker for Windows
Docker for Windows is an application by Docker in cooperation with Microsoft to be able to use Docker Containers on a PC for software development. This is possible with Hyper-V and in newer Windows versions with WSL.
This single command makes the sorcery:
docker run --name mssql -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=TestPass123#" -p 31000:1433 -d mcr.microsoft.com/mssql/server:2017-latest-ubuntuThis command causes:
- downloads the Docker Image MSSQL 2017 on Ubuntu.
- accepts the EULA.
- sets the default password of the admin user “SA” to “TestPass123#”.
- sets the local port 31000 for this Docker container.
- give the Docker container the name “mssql”
If the command executes successfully, the Docker container is running.
You can stop the Container with docker stop mssql and start it again with docker start mssql
To list all your container - to check if the container is running or not - you can use docker ps -a
Microsoft MSSQL on DockerHub
DockerHub is the central place for Docker Images.
The official Docker Hub page for the MSSQL Server (managed by Microsoft) is: https://hub.docker.com/_/microsoft-mssql-server
Related articles
- 2 min read
Use a MSSQL Server 2017 Docker Container with Full-Text Search Support
By default, there is currently no Full-Text Search Support in the Docker Images for Microsoft SQL Server 2017 or 2019 by Microsoft. The only …
- 15 min read
Stop Using nginx as Your Default Static File Server in Docker
In the week of October 21, 2026, government portals in the Netherlands, Finland and Germany, hospital websites and several large companies …
- 11 min read
Containerizing .NET in 2026 Without a Dockerfile
Most .NET Dockerfiles repeat the same five steps: restore, publish, select the matching Microsoft runtime image, copy the output and start …
BEN ABT
Ben is Chief Engineering Officer and Principal Software Engineer at Medialesson.de, with a strong focus on .NET and Microsoft Azure. In his professional role, he designs and builds highly scalable platforms for hybrid and cloud-based scenarios. He also advises companies and C-levels on migrating to the sovereign cloud.
He runs myCSharp.de, the largest and most active German-speaking C# community forum, actively contributes to both his own and external open-source projects and regularly shares his knowledge through his blog, at community events, conferences and as a writer for technical magazines.
Let's Work Together
Looking for an experienced Platform Architect or Engineer for your next project? Whether it's cloud migration, platform modernization or building new solutions from scratch - I'm here to help you succeed.