Application connection with Azure SQL MI using custom domain name

Question

We are using custom domain name for application connectivity with Onpremise SQL Server and planning to migrate the database to Azure SQL MI now. We have created 2 SQL Managed instances in 2 different regions and created failover group as well. I want to create new user like 'login@servername' for application connectivity but not sure which servername I have to use here for connection.

E.g
Primary instance name: miprimary.database.windows.net
Secondary instance name: misecondary.database.windows.net
Failover group name: fgprimary.database.windows.net

Custom dns name: stage.mydns.com

Not sure how to create new user for application connection? login@fgprimary or login@miprimary?

I have migrated non prod database to Azure SQL MI and there is only one target SQL MI (e.g mi.database.windows.net) & no failover created. I have created new login as login@mi for application connection using custom domain name for non prod and it worked fine.

Reference:
https://techcommunity.microsoft.com/t5/azure-database-support-blog/how-to-use-different-domain-name-to-connect-to-azure-sql-db/ba-p/1217805
https://stackoverflow.com/questions/33943854/can-you-add-a-custom-domain-name-for-an-azure-sql-connection-so-not-using-xxxx

Answer 1

Hi, @Santhamoorthy M Thanks for posting your question in the Microsoft Q&A forum.
I would recommend login@fogname (failover group name).

Please let me know if you find any issues.
Regards
Geetha

Answer 2

Thanks @GeethaThatipatri-MSFT . I will try this login@failovergroupname for connection.