Can't deploy Azure SQL Database to Azure Troubleshooter using DacFX
I am unable to deploy Azure SQL Database to Azure Deny Access Group using Read / Write listener endpoint from VS2015 / 17 Database Project, publish or use DACFx? I am using a private user with the appropriate permissions and have proven that it works by deploying directly to the main Azure SQL database server, but not to the failover group read / write listener.
I am getting the same exception using DacFX or directly publishing VS2015 / 17.
Exception Message:
Could not deploy package.
Inner Exception Message:
Unable to connect to master or target server '<MY DATABASE>'. You must have a user with the same password in master or target server '<MY DATABASE>'.
StackTrace:
at Microsoft.SqlServer.Dac.DeployOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
at Microsoft.SqlServer.Dac.OperationExtension.Execute(IOperation operation, DacLoggingContext loggingContext, CancellationToken cancellationToken)
at Microsoft.SqlServer.Dac.DacServices.InternalDeploy(IPackageSource packageSource, Boolean isDacpac, String targetDatabaseName, DacDeployOptions options, CancellationToken cancellationToken, DacLoggingContext loggingContext, Action`3 reportPlanOperation, Boolean executePlan)
at Microsoft.SqlServer.Dac.DacServices.Deploy(DacPackage package, String targetDatabaseName, Boolean upgradeExisting, DacDeployOptions options, Nullable`1 cancellationToken)
source to share
This issue is caused by DacFx opening a connection to the main database behind the scenes. Currently the failover group does not include the master database because it will require replication and the master cannot be replicated - the masters on the primary and secondary servers are independent and can be written. This is a known issue and we address it by treating the wizard as a special case. We will allow connection to it on the server pointed to by the listener.
source to share