Deploying to Azure SQL Database inside a Azure Failover Group

Question

I'm unable to deploy may dacpac package when connecting to Azure SQL Failover Group.

Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package.
Error SQL72016: Cannot open Failover Group "****.database.usgovcloudapi.net" requested by the login. The login failed.

The same works if I use either primary or secondary server instead. There are some discussions about the "master" database being unavailable since it isn't replicated by design.

Has this been resolved or is there a workaround?

Can you try connecting to .database.windows.net,1433 using the same credentials ? How are you trying to deploy dacpac, what are you using for connection ? — KarthikBhyresh-MT, Jul 28 '21 at 09:10
I'm using the server's admin account to .usgovcloudapi.net,1433 — user3688401, Aug 05 '21 at 21:05

score 0 · Answer 1 · answered Jul 29 '21 at 12:35

0

As per product group, logins will not be moved, we need to create logins in the Secondary as well.

answered Jul 29 '21 at 12:35

KarthikBhyresh-MT

4,560
2
5
12

Deploying to Azure SQL Database inside a Azure Failover Group

1 Answers1