无法使用github操作连接到Server

Question

从上周五开始，我就一直在试图解决这个问题，我正在尝试从我的.net应用程序连接到Server数据库。有人能指出我做错了什么吗？

name: .NET
on:
  push:
    branches: [ CI567 ]
  pull_request:
    branches: [ CI567 ]

jobs:
  container-job:
    runs-on: ubuntu-latest
    services:
      sql.data:
        image: mcr.microsoft.com/mssql/server:2019-latest
        env:
          SA_PASSWORD: WhatAmIDoing&Wrong
          ACCEPT_EULA: Y
        ports:
          - "1433:1433"
    steps:
    - name: list container images
      run: docker ps -a
    - name: checkout
      uses: actions/checkout@v2
    - name: Setup .NET
      uses: actions/setup-dotnet@v1
      with:
        dotnet-version: 5.0.x
    - name: Restore dependencies
      run: dotnet restore
      working-directory: ./LabManager
    - name: Build
      run: dotnet build --no-restore
      working-directory: ./LabManager
    - name: Restore donettool
      run: dotnet tool install --global dotnet-ef
      working-directory: ./LabManager
    - name: update database
      run: dotnet-ef database update --no-build
      working-directory: ./LabManager
    - name: Test
      run: dotnet test --no-build --verbosity normal
      working-directory: ./LabManager

下面是连接字符串：

  "ConnectionStrings": {
    "Test": "server=localhost,1433; User Id='SA'; Password='WhatAmIDoing&Wrong'"
  },

这是一个错误：

Microsoft.Data.SqlClient.SqlException (0x80131904)：在建立到Server的连接时发生了与网络相关的或特定于实例的错误。找不到或无法访问服务器。验证实例名是否正确，以及Server是否配置为允许远程连接。(提供程序: TCP提供程序，错误: 35 -捕获了内部异常)

System.Net.Internals.SocketExceptionFactory+ExtendedSocketException (00000005，0xFFDFFF)：名称或服务未知

我试过用单和双密码来引用密码。使用docker run创建Server容器。所有这些都会导致此错误消息。

Answer 1

将连接字符串中的server更改为Data Source

"ConnectionStrings": {
    "Test": "Data Source=localhost,1433; User Id='SA'; Password='WhatAmIDoing&Wrong'"
  },