Active Directory Universal email usernames

jsaintamourjsaintamour Posts: 1 New member
in SQL Prompt
Hello,
  Seems like sql prompt may have a problem with a Active Directory Universal logins when they are email addresses.

 Is there a workaround or fix for this ? I see this error in the log when my username has user@mediacom.com

System.Data.SqlClient.SqlException (0x80131904): Cannot open server "mediacom.com" requested by the login.  The login failed.

Any help would be appreciated, Thanks!


Tagged:
· Share on Twitter

Answers

  • RobynRobyn Posts: 196 Gold 1
    Hi 

    Thanks for your post. 

    We are not entirely sure why it has stopped working!     The Azure AD logins just happened to work previously but were never tested by Redgate and therefore not officially supported.

    If it's an option to you, you may want to try SSMS 17.9.1 If its the SSMS 18 upgrade that you have noticed this issue in!
    Kind regards

    Robyn Edwards | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • VemundHagaVemundHaga Posts: 2 Bronze 1
    Hello!
    This is still a problem in SQL Prompt 9.5.20.11737 running in SSMS 18.3.1. I installed SSMS 17.9.1 and SQL Prompt is working there using Active Directory - Universal with MFA support.

    Best regards,
    Vemund Haga


    · Share on Twitter
Sign In or Register to comment.