What does the following imply? "You cannot transfer an Azure SQL database with Microsoft Entra authentication enabled to a different directory."

Question

I am looking to transfer an Azure subscription to a different Microsoft Entra directory. As part of this process, I want to understand the impact on my Azure SQL databases that use Microsoft Entra authentication. The documentation states that **"You cannot transfer an Azure SQL database with Microsoft Entra authentication enabled to a different directory."
**
Does this mean the database itself cannot be transferred at all or does it only affect the authentication settings? Will I lose access to my data?

Answer 1

Hi @Thabang Xabanisa
Thank you for posting your issue on Microsoft Q&A.

I understand that you are looking to transfer an Azure subscription to a different Microsoft Entra directory.

As per document "The subscriptions of a Flexible Server with Microsoft Entra authentication enabled can't be transferred to another tenant or directory".

This means the database itself cannot be transferred because the subscription itself is not transferred to another tenant or directory, if transferred you will lose access to data.

Only the administrator based on a Microsoft Entra account can create the first Microsoft Entra ID contained database user in a user database.

A Flexible Server matches access tokens to the Azure Database for MySQL Flexible Server users using the user's unique Microsoft Entra user ID instead of the username.
Follow the document for more information: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-azure-ad-authentication?source=recommendations

Hope this helps. Do let us know if you have any further queries.

If this answers your query, do click `Accept Answer` and `Yes`.