Docker - 第三章 | 安裝 MSSQL

---

在Windows 環境建立MSSQL。

開始前需先下載Docker Desktop on window，參考連結官方教學

搜尋 Image

---

docker search mssql

img

在Docker Hub搜尋mssql都找不到Microsoft官方的image，後來直接用 Google 搜詢 [docker mssql image]就有了。

拉取 Image

---

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

img

查看 Image

---

docker images

img

執行 Image

---

(為了方便閱讀下面的程式碼有換行 要貼到命令提示字元前請把換行刪除哦!)

docker run -e "ACCEPT_EULA=Y" 
-e "MSSQL_SA_PASSWORD=需要輸入一個超級困難的密碼" 
-p 1433:1433 
--name 輸入你的container名稱(當然是要英文來者)  
-d mcr.microsoft.com/mssql/server:2022-latest 

• -e ACCEPT_EULA=Y : 設定環境中授權條款同意書 ( Y )

• -e "MSSQL_SA_PASSWORD：需要輸入一個超級困難的密碼" : 請輸入一個Really Strong PWD

• -p 1433:1433 ：設定連線阜號，那為什麼有兩個呢？因為第一個是你本機的另外一個是Container的

• --name：輸入你的containder名稱啦！！！

• -d microsoft/mssql-server-linux (Linux)：-d 是run container background 好了之後show container ID給我就好的意思 後面的就是IMAGE名稱啦

• -d mcr.microsoft.com/mssql/server:2022-latest (Windows)

img

[Windows]

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=!QAZ2wsx" -p 1433:1433 --name MSSQL2022 -d mcr.microsoft.com/mssql/server:2022-latest

[Mac]

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=\!QAZ2wsx" -p 1433:1433 --name MSSQL2022 -d mcr.microsoft.com/mssql/server:2022-latest

容器配置

---

Requirements

---

* This image requires Docker Engine 1.8+ in any of their supported platforms.

* At least 2GB of RAM (3.25 GB prior to 2017-CU2). Make sure to assign enough memory to the Docker VM if you're running on Docker for Mac or Windows.

* Requires the following environment flags
"ACCEPT_EULA=Y"
"MSSQL_SA_PASSWORD="
"MSSQL_PID=(default: Developer)"

* A strong system administrator (SA) password: At least 8 characters including uppercase, lowercase letters, base-10 digits and/or non-alphanumeric symbols.

Environment Variables

---

You can use environment variables to configure SQL Server on Linux Containers.

ACCEPT_EULA
confirms your acceptance of the End-User Licensing Agreement.

MSSQL_SA_PASSWORD
is the database system administrator (userid = 'sa') password used to connect to SQL Server once the container is running. Important note: This password needs to include at least 8 characters of at least three of these four categories: uppercase letters, lowercase letters, numbers and non-alphanumeric symbols.

MSSQL_PID
is the Product ID (PID) or Edition that the container will run with. Acceptable values:

* Developer : This will run the container using the Developer Edition (this is the default if no MSSQL_PID environment variable is supplied)
* Express : This will run the container using the Express Edition
* Standard : This will run the container using the Standard Edition
* Enterprise : This will run the container using the Enterprise Edition
* EnterpriseCore : This will run the container using the Enterprise Edition Core

For a complete list of environment variables that can be used, refer to the documentation here.

查看 Container

---

docker ps

img

刪除Container

---

(不想重做Container可以跳過)

建立Container先停止運行中的Container

docker stop [Container ID]

刪除Container

docer rm [Container ID]

重新查詢一次Container，目前已經沒有了

img

登入管理介面

使用SSMS測試連線

---

http://localhost:1433/ 預設用戶/密碼：sa/******

img

img

連線成功了