First published on MSDN on Sep 19, 2017
This will be a very short post to address what appears to be a slight trend in support at the moment.
When attempting a deplo...
Updated Mar 14, 2019
Version 2.0
Blog Post
1 MIN READ
Deployment fails with 'Unable to connect to master or target server 'mydb_svr'. You must have a user with the same password in master or target server 'mydb-db'
Hi, I am also facing a similar kind of issue and the following are the steps I have followed.
1. I have VS 2019 database project "TestDBProject" in which SQL objects Tables/Stored Procedure etc. creation scripts available.
2. Trying to deploy the TestDBProject.dacpac file of the above project into Azure SQL Database using "Azure SQL Database Deployment" task in VSTS Release pipeline which is throwing the following error.
Unable to connect to master or target server 'TestDB'. You must have a user with the same password in master or target server 'TestDB'.
3. So I have tried updating "TestDBProject.sqlproj"(by opening it in notepad) the DSP with the below 2 options and created the respective "TestDBProject.dacpac" file by building the project.
<DSP>Microsoft.Data.Tools.Schema.Sql.Sql130DatabaseSchemaProvider</DSP>
<DSP>Microsoft.Data.Tools.Schema.Sql.Sql140DatabaseSchemaProvider</DSP>
4. I even added the following MSBuild Arguments in the Build pipeline "Visual Studio Build" Task, but no use still getting above same error.
/p:AllowIncompatiblePlatform=true
/p:DSP=Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider
Can you pl. let me know what am I missing or any suggestions are appreciable.