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
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
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
Thanks @GeethaThatipatri-MSFT . I will try this login@failovergroupname for connection.