Unable to connect to master or target server 'xyz'. You must have a user with the same password in master or target server 'xyz'.

Satish Kumar T 21

When I am trying to deploy .dacpac file using TFS 2017 CI/CD Pipelines "Azure SQL Database Deployment" task in the Release pipeline it is throwing the following error.

Could not deploy package.
Unable to connect to master or target server 'xyz'. You must have a user with the same password in master or target server 'xyz'.
Azure SQL Dacpac task failed.

I am able to connect the same Azure Database using SSMS v18 and same servername, LoginId and Password and able to deploy the same .dacpac file

Anurag Sharma 17,606 Reputation points

2020-11-30T06:23:47.303+00:00

Hi @Satish Kumar T , welcome to Microsoft Q&A forum.

From the error message it looks issue with server credentials but as you mentioned you were able to connect using SSMS. Sometimes the error message could be misleading so we need to try out alternatives. I was trying to achieve the same using below article and was successfully able to deploy the dacpac file. Could you please go through it and let me know if you see any difference in the way you are trying to achieve? If still not working, I can create a step by step document and we can walk through it.

https://microsoft.github.io/PartsUnlimited/iac/200.2x-IaC-CDAzureSQLdbwithVSTSandVS.html
Satish Kumar T 21 Reputation points

2020-11-30T08:16:31.677+00:00

Hi @AnuragSharma-MSFT , Thanks for your reply, i have followed same steps that was mentioned in the above link, but will try again. I feel like there is some issue with Task#2, step#7Azure Connection Type: Azure Resource Manager creation at my end. Can you provide more details on creating new Azure Resource Manager.
Whether I give correct or incorrect credentials, I am getting same error.
Satish Kumar T 21 Reputation points

2020-11-30T09:43:05.687+00:00

@AnuragSharma-MSFT , The link you have provided is making use of Azure DevOps pipelines, whereas I am making use of TFS 2017 for CI/CD Pipelines. Also I am using Visual Studio 2017 and SSMS V17.1.
Can we have a quick call to nail down the issue as I am struggling on same issue from past one week.
Anurag Sharma 17,606 Reputation points

2020-11-30T10:17:55.013+00:00

Hi @Satish Kumar T , thanks for reverting back. Can you please tell me if you are using on-premise TFS or VSTS? If you could provide few screenshots for the pipeline you created and the error you get while configuring the database deployment task, it would be helpful. Also which SQL Server version you are using?

Meanwhile, I will try to reproduce the same on TFS (based on your inputs) and then we can connect to have resolution.

Accepted answer

Anurag Sharma 17,606 Reputation points

2020-12-02T18:42:40.59+00:00
Hi @Satish Kumar T , as discussed over the call, to resolve this issue we need to make below changes:

Change the compatibility level of Azure SQL database to 130 at Azure database level

Change the target platform of Database Project to Microsoft Azure SQL Server V12

Glad it worked out for you.

----------

Please select 'Accept Answer' if this helped you as it could help other community members looking for similar query.
Please sign in to rate this answer.

1 person found this answer helpful.
Satish Kumar T 21 Reputation points

2020-12-02T18:45:54.953+00:00

@AnuragSharma-MSFT Thank you for your timely help. The above settings worked like a charm for me!!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Unable to connect to master or target server 'xyz'. You must have a user with the same password in master or target server 'xyz'.

0 additional answers

Your answer