Azure SQL DB using AAD and MFA

• 
  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
  

  DanC January 14, 2020 16:43

  - 0 +
• 
  Is there an update on this issue?

  BonnieF August 20, 2020 10:18

  - 0 +
• 
  Hi @BonnieF
  
  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
  

  DanC August 20, 2020 10:23

  - 0 +
• 
  Is there some reason you aren't bringing up the standard AAD interactive MFA dialog but instead requiring an application ID?

  BonnieF August 20, 2020 17:19

  - 0 +
• 

  BonnieF said:

  Is there some reason you aren't bringing up the standard AAD interactive MFA dialog but instead requiring an application ID?

  Echoing Bonnie's comments. It doesn't seem appropriate to need to create an application within Azure to use SQL Compare (and likewise, SQL Multiscript). Are there any plans to implement a more "standard" approach to authentication?

  AndrewStevens October 26, 2020 18:23

  - 0 +
• 
  Azure Interactive Authentication is no longer an option since the last update and the MFA is throwing an error.

  kdevine September 13, 2021 16:17

  - 0 +
• 

  AndrewStevens said:

  BonnieF said:

  Is there some reason you aren't bringing up the standard AAD interactive MFA dialog but instead requiring an application ID?

  Echoing Bonnie's comments. It doesn't seem appropriate to need to create an application within Azure to use SQL Compare (and likewise, SQL Multiscript). Are there any plans to implement a more "standard" approach to authentication?

  @BonnieF
  
   The reason for this is because SQL Compare and other tools need their own application ID, whereas other tools like SSMS have a built-in app id that is preauthorized.
  
  
  

  DanC September 14, 2021 08:56

  - 0 +
• 

  kdevine said:

  Azure Interactive Authentication is no longer an option since the last update and the MFA is throwing an error.

  Hi Kevin, there's currently an issue with one of the Microsoft libraries, could you please reach out and submit a support ticket for us to investigate this?
  
  https://productsupport.red-gate.com/hc/en-us
  

  DanC September 14, 2021 08:58

  - 0 +
• 
  Hi,
  
  For anyone who also experienced issues with MFA throwing an error please see the following post to address this: https://forum.red-gate.com/discussion/88435/active-directory-interactive-now-gone-and-mfa-doesnt-work

  DanC September 17, 2021 08:41

  - 0 +

Add comment

Please sign in to leave a comment.