sql-server - 无法通过sql management studio从docker容器连接到ms sql数据库

Question

我尝试运行一个 microsoft/mssql-server-windows-express 容器 ->

docker run -d -p 1433:1433 -e sa_password=password -e ACCEPT_EULA=Y microsoft/mssql-server-windows-express

我得到下一个错误 ->

docker: Error response from daemon: failed to create endpoint hopeful_kowalevski on network nat: HNS failed with error : The process cannot access the file because it is being used by another process.

我想是因为我环境上的sql server监听了1433端口。然后我尝试使用其他端口运行容器，例如 5000:1433 并且容器运行良好。

然后我尝试通过 sql management studio 使用“ip-address”,5000 从容器连接到数据库。但是我得到了 Microsoft SQL Server，错误:258。

Answer 1

据我所知，问题在于 DB 的密码不正确。密码与数据库规则不匹配。正确的密码应该包含

at least 8 characters long and contain characters from three of the following four sets: Uppercase letters, Lowercase letters, Base 10 digits, and Symbols -> https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-2017&pivots=cs1-bash#pullandrun2017