Options
MFA Active Directory Authentication Error
a.higgins
Posts: 90 Bronze 2
in SQL Compare
I'm trying to connect to a SQL Managed Instance using the new 'Active Directory universal with MFA Authentication' authentication type, but running into an 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:
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:
Active Directory authentication error: 
AADSTS7000218: the request body must contain the following parameter: 'client_assertion' or 'client_secret'.
(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 14.6.12.20158), or is there a different setup we have to use to connect to a SQL Managed Instance?
Tagged:
Answers
I've noticed this error come up a couple of times and it's been pointed out that this can occur when the Redirect URI is selected as "Mobile". If this is changed to "Web", then the issue should be resolved.
Let me know if this works or if you need further help!
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
You may be interested to know that the documentation page has been updated and this may help!
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?