Share via

SSDT Release pipleline issue in Azure devops

Muddu Venkata Narasimha Murthy 21 Reputation points
2021-03-03T15:45:28.043+00:00

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 : https://learn.microsoft.com/azure/devops/pipelines/tasks/deploy/sql-dacpac-deployment-on-machine-group
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 'abcd12345.xx.xxxxxx.com'.
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.
37,800 questions
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest