Azure Active Directory Password Authentication Support

ErinDErinD Posts: 3 Bronze 1
in SQL Prompt
I've found some older questions/feedback with questions/concerns about SQL Prompt not supporting Azure Active Directory authentication methods for Azure SQL Database (Managed Instance), and I've run into problems with AAD Password Authentication.

Is support for Azure SQL Database going to be coming in the near future (3 - 6 months)?  I see cloud DB support is in development.  Does this include Azure SQL Database with AAD authentication?
Tagged:
· Share on Twitter

Best Answer

  • Tianjiao_LiTianjiao_Li Posts: 684 Rose Gold 5
    Answer ✓
    @ErinD

    Thanks for your post.

    We are adding support for Azure AD MFA and it should work with Azure AD password authentication though.

    Which version of SSMS are you using? Could you upgrade to the latest version of SQL Prompt (10.1.7) and check again?
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter

Answers

  • ErinDErinD Posts: 3 Bronze 1
    Thank you.  I think I had an older version of SQL Prompt installed. I just reinstalled it this morning, and I it is now working for with Azure AD Password authentication.

    Sorry for not checking my version.
    Erin
    · Share on Twitter
  • JakeJake Posts: 1 New member
    Has MFA support been added? I am on 10.1.7.15015 and it wont load suggestions
    · Share on Twitter
Sign In or Register to comment.