azure-devops - 无法在托管代理上的 azure 管道任务中连接到 localdb

Question

无法连接到 Azure 管道中正在运行的 localdb 实例。在下图上运行:使用 VS2019 托管 Windows 2019。

尝试运行 SQLCMD 时出现以下错误:

SQLCMD : Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Named Pipes Provider: Could not open a connection to 
SQL Server [2].

我不确定如何指定连接我已经尝试了一些东西。

下面是我的azure-pipelines.yml

variables:
  solution: 'source/**/*.sln'
  buildPlatform: 'Any CPU'
  buildConfiguration: 'Release'
  dbInstance: 'MSSQLLocalDB'
  dbShare: 'MSSQLLocalDBShare'
  attachDb: 'azure\attachDB.sql'

steps:
- task: PowerShell@2
  inputs:
    targetType: 'inline'
    script: |
      SQLLOCALDB START $(dbInstance)
      SQLLOCALDB SHARE $(dbInstance) $(dbShare)
      SQLLOCALDB INFO $(dbInstance)
      SQLCMD -s ((sqllocaldb info $(dbInstance) | Select-String -Pattern "Instance pipe name") -split " ")[3] -i $(attachDb)

对于“SQLCMD”行，我也尝试了以下并得到了同样的错误:

 SQLCMD -s "(localdb)\.\MSSQLLocalDBShare" -i "azure\attachDB.sql"

这是信息的输出:

LocalDB instance "MSSQLLocalDB" started.
Private LocalDB instance "MSSQLLocalDB" shared with the shared name: "MSSQLLocalDBShare".

Name:               MSSQLLocalDB
Version:            13.1.4001.0
Shared name:        MSSQLLocalDBShare
Owner:              fv-az8\VssAdministrator
Auto-create:        Yes
State:              Running
Last start time:    7/9/2019 3:36:04 PM
Instance pipe name: np:\\.\pipe\LOCALDB#238E1FEF\tsql\query

Answer 1

您可以尝试改用 Invoke-SqlCmd cmdlet 吗？在后台，它仍然调用 SQLCMD，但这个更容易驯服。

- task: PowerShell@2
    inputs:
      targetType: 'inline'
      script: |
  SQLLOCALDB START $(dbInstance)
  SQLLOCALDB SHARE $(dbInstance) $(dbShare)
  SQLLOCALDB INFO $(dbInstance)

- task: PowerShell@2
  inputs:
    targetType: 'inline'
    script: 'Invoke-Sqlcmd -InputFile $(attachDb) -ConnectionString "Server=(localdb)\mssqllocaldb;Trusted_Connection=True;MultipleActiveResultSets=false;" -Verbose'