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:
1docker run --name mssql -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=TestPass123#" -p 31000:1433 -d mcr.microsoft.com/mssql/server:2017-latest-ubuntu
This 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
Aug 30, 2018 - 4 min read
Run ASP.NET Core with .NET Framework in a Docker Container
Sometimes you still have the requirement that the .NET Framework is needed - but you still want to use ASP.NET Core and Docker.
Jul 28, 2018 - 2 min read
Run ActiveMQ in Docker on your Synology
If you have a Synology with an x86 CPU it is very easy to run Docker Containers on your Synology. If you have a ARM-based Synology systems, …
Jul 23, 2018 - 2 min read
Run MongoDB in Docker on your Synology
If you have a Synology with an x86 CPU it is very easy to run Docker Containers on your Synology. If you have a ARM-based Synology systems, …
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.