📝 Get your FREE cheat sheet of Docker commands: https://databasestar.mykajabi.com/lpkj-docker-cheat-sheet/?video=Y7CMbve-Mos
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql-simplified/?video=Y7CMbve-Mos
If you want to run SQL Server in a Docker container, you can download it from a Microsoft website using Docker commands.
In this video I'll demonstrate where the images are, how to download one, how to run the container, and connect to it using SSMS.
⏱ TIMESTAMPS:
00:00 - Prerequisites
00:23 - Download the image
01:35 - Docker Run command
03:53 - Connect
05:11 - Stop the docker container
🔗 VIDEO LINKS:
Container registry: mcr.microsoft.com
🔗 COMMANDS USED:
docker pull mcr.microsoft.com/mssql/server:2019-latest
docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=yourStrong(!)Password" -p 1433:1433 --name sqlserver --hostname sqlserver -d mcr.microsoft.com/mssql/server:2019-latest
docker ps -a
docker stop sqlserver
