Docker install sql server 2017

最新推荐文章于 2025-04-17 11:50:06 发布

仙仙熊

最新推荐文章于 2025-04-17 11:50:06 发布

阅读量398

点赞数

CC 4.0 BY-SA版权

分类专栏： DOCKER_SQLSERVER

本文链接：https://blog.youkuaiyun.com/weixin_39392627/article/details/85642763

DOCKER_SQLSERVER 专栏收录该内容

3 篇文章

订阅专栏

本文详细介绍如何在CentOS7环境下通过Docker部署SQLServer2017，包括下载镜像、创建容器、配置参数及解决常见问题等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

env: CentOS 7
Docker docker-ce-18.05.0.ce
SQL Server 2017 for Linux

可以參考:
https://hub.docker.com/r/microsoft/mssql-server-linux/
https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-2017

1.透過docker指令下載SQL Server 2017 image
command:

sudo docker pull microsoft/mssql-server-linux:2017-latest

[root@localhost ~]# sudo docker pull microsoft/mssql-server-linux:2017-latest

2017-latest: Pulling from microsoft/mssql-server-linux
f6fa9a861b90: Pull complete

da7318603015: Pull complete

6a8bd10c9278: Pull complete

d5a40291440f: Pull complete

bbdd8a83c0f1: Pull complete

3a52205d40a6: Pull complete

6192691706e8: Pull complete

1a658a9035fb: Pull complete

103fa96eca85: Pull complete

4105e5c7e280: Pull complete

Digest: sha256:4ef33b1d0b2f264550c152e24a87322daae40b090d3ba32f1241cb0fd4510421

Status: Downloaded newer image for microsoft/mssql-server-linux:2017-latest

[root@localhost ~]#

2.確認下載的docker image
command:

docker image ls

[root@localhost ~]# docker image ls

REPOSITORY TAG IMAGE ID CREATED SIZE
microsoft/mssql-server-linux 2017-latest bbe2822dfe38 33 hours ago 1.43GB

hello-world latest e38bc07ac18e 6 weeks ago 1.85kB

[root@localhost ~]#

3.開始使用image建立container
指定image "microsoft/mssql-server-linux:2017-latest"建立container名稱為"sql1"
sa的密碼指定為"Passw0rd@1234"

command:

sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Passw0rd@1234' \
 -p 1433:1433 --name sql1 \
 -d microsoft/mssql-server-linux:2017-latest

[root@localhost ~]# sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Passw0rd@1234' \

> -p 1433:1433 --name sql1 \

> -d microsoft/mssql-server-linux:2017-latest

c6bdad51c6d288836e00bd116ceb1386732bb78331d817973b8b16e1cc9c9f6c

[root@localhost ~]#

4.檢查建立的container
command:

sudo docker ps -a

[root@localhost ~]# sudo docker ps -a

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

c6bdad51c6d2 microsoft/mssql-server-linux:2017-latest "/opt/mssql/bin/sqls…" 3 minutes ago Exited (1) 3 minutes ago sql1

出現Exited (1) 3 minutes ago，主要原因是記憶體不足2GB，請將主機記憶體加到2GB。
執行以下指令停止重啟container即可。
c6bdad51c6d2是container id
command:
docker restart c6bdad51c6d2