docker中无法启动mssql

Question

C:\Users\poboh>docker run -e ‘ACCEPT_EULA’ -e ‘SA_PASSWORD=PaSSword12!’ -p 1433:1433 -d microsoft/mssql-server-linux
5ae946e91edcccffa1ea139d9e4b4c1171b2d4928ae3743e83768f53b284dd1d
docker: Error response from daemon: Ports are not available: listen tcp 0.0.0.0:1433: bind: An attempt was made to access a socket in a way forbidden by its access permissions.

C:\Users\poboh>docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
microsoft/mssql-server-linux latest 314918ddaedf 2 years ago 1.35GB

C:\Users\poboh>docker run -e “ACCEPT_EULA” -e “SA_PASSWORD=PaSSword12!” -p 1433:1433 -d microsoft/mssql-server-linux
b8574955575939b1e82a17492f7306028aee816b4e9567c352140758e40b5bb7
docker: Error response from daemon: Ports are not available: listen tcp 0.0.0.0:1433: bind: An attempt was made to access a socket in a way forbidden by its access permissions.

C:\Users\poboh>docker run -e “ACCEPT_EULA” -e “SA_PASSWORD=PaSSword12!” -p 1444:1433 -d microsoft/mssql-server-linux
bd64e6c1c2b7fbf03eb3e2e98e38e6a77704688c920176c55391319cf09ae56f
docker: Error response from daemon: Ports are not available: listen tcp 0.0.0.0:1444: bind: An attempt was made to access a socket in a way forbidden by its access permissions.

用了各种办法，重装docker，单双引号更换，更换端口，都无法启动mssql

Answer 1

阿莱克斯刘 2021-01-04 13:00:11

hello 同学你好，你目前的系统中有没有安装过sql server？如果安装过，那么应该是端口冲突。如果没安装过，那你需要检查一下端口占用情况。除此以外，你的系统是什么版本？win 家庭版在运行docker会产生各种奇奇怪怪的情况，请一定要使用windows 专业版。

Answer 2

提问者 要你命三千 2021-01-03 12:29:43

修改端口号后，vs该如何连接数据库

C:\Windows\system32>docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=PaSSword12!" -p 14338:1433 -d microsoft/mssql-server-linux

72b6c1620ff0b5c7d0071e6492868f4f777808f24b7abc02be80419caeacaf26

在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接。 (provider: Named Pipes Provider, error: 40 - 无法打开到 SQL Server 的连接) (Microsoft SQL Server，错误: 2)

• Vardis #1

  改端口后 在vs连接数据库窗口中写127.0.0.1,14338

• 阿莱克斯刘 #2

  可以试试链接localhost:14338

Answer 3

提问者 要你命三千 2021-01-03 10:54:19

又重新安装了docker 实在是没法了，情况如下：

C:\Users\poboh>docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=PaSSword12!" -p 1433:1433 -d microsoft/mssql-server-linux

82e9294fa8b23cae11fdb58726ee897a1742a68beed7c158a81f2cc18e8124c9

docker: Error response from daemon: Ports are not available: listen tcp 0.0.0.0:1433: bind: An attempt was made to access a socket in a way forbidden by its access permissions.

C:\Users\poboh>docker ps -a

CONTAINER ID   IMAGE                          COMMAND                  CREATED          STATUS    PORTS     NAMES

82e9294fa8b2   microsoft/mssql-server-linux   "/opt/mssql/bin/sqls…"   20 seconds ago   Created             crazy_meninsky

C:\Users\poboh>docker logs 82e9294fa8b2