【docker】Docker安装Microsoft SQLServer详解

2018-08-08

1 拉取SqlServer镜像

sudo docker pull mcr.microsoft.com/mssql/server:2017-latest

sudo docker pull mcr.microsoft.com/mssql/server:2019-latest

2 运行容器，多种版本参考

sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=DavidQQ986945193" \
   -p 1433:1433 --name sql1 --hostname sql1 \
   -d mcr.microsoft.com/mssql/server:2019-latest

sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=DavidQQ986945193"  -p 1433:1433 --name sql1  -d mcr.microsoft.com/mssql/server:2017-latest

3 可以查看容器是否运行，或者进入容器内部

sudo docker ps -a

docker exec -t sql1 cat /var/opt/mssql/log/errorlog | grep connection

sudo docker exec -it sql1 "bash"

4 参考文档

https://docs.microsoft.com/zh-cn/sql/linux/quickstart-install-connect-docker?view=sql-server-ver16&pivots=cs1-bash

https://hub.docker.com/_/microsoft-mssql-server

#Docker