docker中无法启动mssql

来源:3-9 【选修】基于docker完成 SQL Server 数据库启动

要你命三千

2021-01-02

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

写回答

3回答

阿莱克斯刘

2021-01-04

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

2
0

要你命三千

提问者

2021-01-03

修改端口号后,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)


0
2
阿莱克斯刘
可以试试链接localhost:14338
2021-01-04
共2条回复

要你命三千

提问者

2021-01-03

又重新安装了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


0
0

.Net 开发电商后端API 从0到精通RESTful

. Net 实战+RESTful思想纵深课程,开发优雅RESTful风格API。

977 学习 · 547 问题

查看课程