Active Directory Universal email usernames

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:

Answers

  • RobynRobyn Posts: 173 Silver 5
    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?
  • 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


Sign In or Register to comment.