啟動MS SQL容器發生Ports are not available錯誤

今天要測個MS SQL的東西時，啟動MS SQL容器時發生Ports are not available錯誤。

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=<YourStrong@Passw0rd>" -p 1433:1433 --name sql1 --hostname sql1 -d mcr.microsoft.com/mssql/server:2022-latest
c71dce344559b7e9188144b69329bdeca50e85984742d0c97ea73d3b1a40c5cf
docker: Error response from daemon: Ports are not available: exposing port TCP 0.0.0.0:1433 -> 0.0.0.0:0: listen tcp 0.0.0.0:1433: bind: An attempt was made to access a socket in a way forbidden by its access permissions.

奇怪的是，我用 netstat 查詢，Port 1433 並沒有被佔用。

netstat -a

Active Connections

  Proto  Local Address          Foreign Address        State
  TCP    0.0.0.0:7              kkbruce:0              LISTENING
  TCP    0.0.0.0:9              kkbruce:0              LISTENING
  TCP    0.0.0.0:13             kkbruce:0              LISTENING
  TCP    0.0.0.0:17             kkbruce:0              LISTENING
  TCP    0.0.0.0:19             kkbruce:0              LISTENING
  TCP    0.0.0.0:135            kkbruce:0              LISTENING
  TCP    0.0.0.0:445            kkbruce:0              LISTENING
  TCP    0.0.0.0:1025           kkbruce:0              LISTENING
  TCP    0.0.0.0:2179           kkbruce:0              LISTENING
  TCP    0.0.0.0:5040           kkbruce:0              LISTENING
  TCP    0.0.0.0:7680           kkbruce:0              LISTENING
  TCP    0.0.0.0:49664          kkbruce:0              LISTENING
  TCP    0.0.0.0:49665          kkbruce:0              LISTENING
  TCP    0.0.0.0:49666          kkbruce:0              LISTENING
  TCP    0.0.0.0:49667          kkbruce:0              LISTENING
  TCP    0.0.0.0:49668          kkbruce:0              LISTENING
  TCP    0.0.0.0:59869          kkbruce:0              LISTENING
  TCP    127.0.0.1:7777         kkbruce:0              LISTENING
  TCP    127.0.0.1:19010        kkbruce:0              LISTENING
  TCP    127.0.0.1:29678        kkbruce:0              LISTENING
  TCP    127.0.0.1:62978        kkbruce:0              LISTENING
  TCP    172.23.208.1:139       kkbruce:0              LISTENING
  TCP    172.31.80.1:139        kkbruce:0              LISTENING
  TCP    192.168.8.148:139      kkbruce:0              LISTENING
  TCP    192.168.8.148:1026     20.90.152.133:https    ESTABLISHED

試了好幾次都這樣，利用關鍵字快速在 docker Issues #9272找到一個解法：

net stop winnat
net start winnat

winnat 重啟後就一切正常了。正在奇怪，爬到黑大的一篇文。清除重啟後利用 netsh 查詢是沒有看到 Port 1433。

netsh int ipv4 show excludedportrange protocol=tcp

Protocol tcp Port Exclusion Ranges

Start Port    End Port
----------    --------
     50000       50059     *

* - Administered port exclusions.

這裡比較可惜，我先清 winnat 才看到黑大的文，在此 Docker Case 裡，我沒有找到真正兇手，只找到解決辦法。而我最近確在有大量的 Lab / PoC 使用 Hyper-V，但怎麼會去佔用 Port 1433 呢，這我無法解釋，我也不敢說一定是 Hyper-V 造成的，證據已經被我清的一乾二淨了。哈哈哈！