使用SQL Management Studio连接到Linux上的SQL Server(docker)
问题描述:
如何连接到我使用docker在Linux上创建的SQL Server?使用SQL Management Studio连接到Linux上的SQL Server(docker)
这里是我的Dockerfile:
FROM microsoft/aspnetcore:1.1.2
ARG source
WORKDIR /var/www/aspnetcoreapp
EXPOSE 80
COPY ${source:-obj/Docker/publish} .
ENTRYPOINT ["dotnet", "AspNetCoreWithSqlOnDocker.dll"]
和我的搬运工,撰写:
version: '2.1'
services:
mssql:
image: "microsoft/mssql-server-linux"
environment:
SA_PASSWORD: "[email protected]"
ACCEPT_EULA: "Y"
ports:
- 1533:1533
networks:
- mynetwork
aspnetcorewithsqlondocker:
image: aspnetcorewithsqlondocker
ports:
- 5001:80
build:
context: ./AspNetCoreWithSqlOnDocker
dockerfile: Dockerfile
links:
- mssql
depends_on:
- mssql
networks:
- mynetwork
networks:
mynetwork:
driver: bridge
答
一个docker-compose,基本服务必须暴露端口。这需要调用暴露容器的应用程序看起来像这样:
version: '2.1'
services:
mssql:
expose:
- 1533
aspnetcorewithsqlondocker:
links:
- mssql
您的连接的定义必须是:
HOST: mssql
PORT: 1533
顺便说一句,你不必外面暴露的端口除非你想访问容器外。