Docker install sql server 2017

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