MFA Active Directory Authentication Error
The security team on my end followed the instructions from Using Azure Interactive Authentication - SQL Compare 14 - Product Documentation (red-gate.com) to give me an Application ID to put in. They noted that there wasn't an option for Azure SQL Managed Instance under the 'APIs my organization uses' area in the page, so they used the Azure SQL Database one just in case.
When we tried to connect using that application ID, SQL Compare threw the following error:
(side note - it would be really helpful if I could copy/paste out of that error message window).
So ... was that error message something happening in SQL Compare (I'm running version 184.108.40.20658), or is there a different setup we have to use to connect to a SQL Managed Instance?