Docker中运行的.NET 6 API连接本地非容器化MS SQL Server求助

我有一个运行在Docker中的ASP.NET Core 6 Web API，需要连接本地非容器化的MS SQL Server数据库，但连接失败。通过IP连接远程服务器数据库正常，但使用指定连接字符串时无法成功。本地直接运行应用或连接容器化SQL Server时均正常。

1. 使用的连接字符串 #

var dbHost = "COM-3195\\IMRANMSSQL";
var dbName = "CustomersDb";
var dbPassword = "prg@321654";
var connectionString = $"Data Source={dbHost};Initial Catalog={dbName};User Id=sa;Password={dbPassword}";

2. Dockerfile配置 #

FROM mcr.microsoft.com/dotnet/aspnet:6.0 AS base
WORKDIR /app
EXPOSE 80
EXPOSE 443

FROM mcr.microsoft.com/dotnet/sdk:6.0 AS build
WORKDIR /src
COPY ["CustomerWebService/CustomerWebService.csproj", "CustomerWebService/"]
RUN dotnet restore "CustomerWebService/CustomerWebService.csproj"
COPY . .
WORKDIR "/src/CustomerWebService"
RUN dotnet build "CustomerWebService.csproj" -c Release -o /app/build

FROM build AS publish
RUN dotnet publish "CustomerWebService.csproj" -c Release -o /app/publish /p:UseAppHost=false

FROM base AS final
WORKDIR /app
COPY --from=publish /app/publish .
ENTRYPOINT ["dotnet", "CustomerWebService.dll"]

3. docker-compose.yml配置 #

services:
  customerwebservice:
    image: ${DOCKER_REGISTRY-}customerwebservice
    build:
      context: .
      dockerfile: CustomerWebService/Dockerfile
    extra_hosts:
      - "COM-3195\\IMRANMSSQL:<IP>"

4. 错误日志 #

info: Microsoft.Hosting.Lifetime[14]
      Now listening on: https://[::]:443
info: Microsoft.Hosting.Lifetime[14]
      Now listening on: http://[::]:80
info: Microsoft.Hosting.Lifetime[0]
      Application started. Press Ctrl+C to shut down.
info: Microsoft.Hosting.Lifetime[0]
      Hosting environment: Development
info: Microsoft.Hosting.Lifetime[0]
      Content root path: /app/
info: Microsoft.EntityFrameworkCore.Infrastructure[10403]
      Entity Framework Core 6.0.5 initialized 'CustomerDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer:6.0.5' with options: None
fail: Microsoft.EntityFrameworkCore.Database.Connection[20004]
      An error occurred using the connection to database 'master' on server '<IP>,1433'.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server: Could not open a connection to SQL Server)

5. 可正常工作的容器化SQL Server配置 #

version: '3.4'

networks:
  backend:
services:
  customerdb:
    container_name: customer-db
    image: mcr.microsoft.com/mssql/server:2019-latest
    environment:
      - ACCEPT_EULA=Y
      - MSSQL_SA_PASSWORD=prg@321654
    networks:
      - backend
    ports:
      - 8001:1433 
  customerwebapi:
    container_name: cutomer-api
    image: ${DOCKER_REGISTRY-}customerwebapi
    build:
      context: .
      dockerfile: CustomerWebAPI/Dockerfile
    networks:
      - backend
    ports:
      - 8002:80 
    environment:
      - DB_HOST= customerdb
      - DB_NAME= CustomersDb
      - DB_SA_PASSWORD=prg@321654

解决步骤 #

1. 修正连接字符串与extra_hosts配置 #

• 容器内无法直接识别本地Windows主机名+SQL实例名的组合，extra_hosts仅需映射本地Windows主机名到IP，实例名在连接字符串中单独指定：
  修改docker-compose.yml的extra_hosts：

  extra_hosts:
    - "COM-3195:<你的本地主机IP>"
  

• 确保C#字符串中的反斜杠正确转义，连接字符串格式保持主机名+实例名：

  var dbHost = "COM-3195\\IMRANMSSQL";
  var connectionString = $"Data Source={dbHost};Initial Catalog={dbName};User Id=sa;Password={dbPassword}";
  

2. 确保本地SQL Server配置正确 #

• 启用TCP/IP协议：打开SQL Server配置管理器 → SQL Server网络配置 → 实例IMRANMSSQL的协议 → 启用TCP/IP
• 配置TCP端口：在TCP/IP属性的「IP地址」标签中，找到「IPAll」，设置TCP端口为1433（或自定义端口，需保持一致），重启SQL Server服务
• 允许远程连接：在SSMS中右键服务器 → 属性 → 连接 → 勾选「允许远程连接到此服务器」
• 检查防火墙：确保本地Windows防火墙允许SQL Server端口（默认1433）的入站连接，可临时关闭防火墙测试

3. 直接使用本地IP+实例名连接（备选方案） #

如果主机名映射有问题，可直接在连接字符串中使用本地IP和实例名，无需配置extra_hosts：

var dbHost = "<你的本地主机IP>\\IMRANMSSQL";
var connectionString = $"Data Source={dbHost};Initial Catalog={dbName};User Id=sa;Password={dbPassword}";

4. 验证容器网络连通性 #

进入容器内部，测试与本地SQL Server的网络连通性：

# 进入容器
docker exec -it <容器ID/名称> bash
# 测试端口连通性（需先在容器内安装telnet：apt-get update && apt-get install telnet）
telnet <本地IP> 1433

如果telnet不通，说明网络层面有障碍，优先排查防火墙和SQL Server的TCP配置。

内容的提问来源于stack exchange，提问作者Imran Khan