Top 10 SQL Compare Tips. Watch now.
Azure SQL DB using AAD and MFA

in SQL Compare
SQL Data Compare and SQL Compare don't seem to work with Azure if your databases require Multi Factor Authentication. We are using this and can log into the databases with SSMS using Azure AAD & MFA, but when that user then attempts to run a Compare (Schema or Data), the project fails to log in with error AADSTS50076, saying you must use multi-factor authentication to access.
I have used MFA to access the database, but that's not an option in the Redgate connections. How can I get this working, because currently we are having to use a SQL Server user to perform our compares?
I have used MFA to access the database, but that's not an option in the Redgate connections. How can I get this working, because currently we are having to use a SQL Server user to perform our compares?
Tagged:
Best Answer
-
DanC Posts: 189 Gold 1
Hi @Andeavour so we currently support Azure Active Directory in the latest versions of SQL Compare & Data Compare, however MFA is currently still under development. Please keep an eye on the release notes for further updates!
https://documentation.red-gate.com/sc/release-notes-and-other-versions
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
Answers
So if you update to the latest version of SQL Compare 14, you can use Active Directory Interactive Authentication.
The following document should help: https://documentation.red-gate.com/sc/setting-up-the-comparison/using-azure-interactive-authentication
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?