Using Azure Interactive Authentication (Microsoft Entra ID)
Published 13 December 2022
Requirements
- To use Azure Active Directory (Microsoft Entra ID) with an Azure SQL Database server, the server needs to be assigned an Azure Active Directory admin
Note: If you are using a version older than 14.8.0 please refer to here.
Setting up SQL Compare
In the connection dialog, select Active Directory universal with MFA authentication (Azure) in the Authentication dropdown.
When you click the database refresh button, a popup will open asking you to pick an account to sign in with. Proceed with the sign in process.
Once signed in, you can continue with your comparison.
