SSDT Release pipleline issue in Azure devops

Muddu Venkata Narasimha Murthy 21 Reputation points

Dear All, I have a problem with the release pipleline in Azure devops. I am trying to deploy a database project / SSDT from Azuredevops using git repo, with a deployment group (on-prem build agent server). Build is successful locally and on azure devops. Issue occurs during release after creating a deployment group.

Please advice.

NOTE - Deploying the dacpac to On-Prem SQL database not Azure SQL

Error below

2021-03-02T16:29:42.0588645Z ##[section]Starting: Deploy using : dacpac
2021-03-02T16:29:42.0718050Z ==============================================================================
2021-03-02T16:29:42.0718340Z Task : SQL Server database deploy
2021-03-02T16:29:42.0718581Z Description : Deploy a SQL Server database using DACPAC or SQL scripts
2021-03-02T16:29:42.0718804Z Version : 0.3.23
2021-03-02T16:29:42.0718996Z Author : Microsoft Corporation
2021-03-02T16:29:42.0719286Z Help :
2021-03-02T16:29:42.0719608Z ==============================================================================
2021-03-02T16:29:47.4872820Z *** Could not deploy package.
2021-03-02T16:29:47.4881348Z Unable to connect to master or target server 'DB_DEMO'. You must have a user with the same password in master or target server 'DB_DEMO'.
2021-03-02T16:29:47.6262828Z ##[error]Publishing to database 'DB_DEMO' on server ''.
Initializing deployment (Start)
Initializing deployment (Failed)

2021-03-02T16:29:47.6596779Z ##[section]Finishing: Deploy using : dacpac

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,985 questions
0 comments No comments
{count} votes

Accepted answer
  1. Dave Patrick 426.3K Reputation points MVP

    Devops / TFS is not currently supported here on QnA. The product group for Azure DevOps / TFS actively monitors questions over at

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments No comments

0 additional answers

Sort by: Most helpful