SSMS 22 Azure validation and weird email address

Hi Scott Klein,

It sounds like you're running into an issue with SSMS 22 where it's prompting you with a weird email address when trying to connect to an Azure SQL Database. This is definitely not ideal, especially since you mentioned things worked fine with SSMS 21.

Here are a few things you can try:

Check Authentication Method: Ensure that you're using the correct authentication method. If you are using Active Directory - Universal with MFA, note that SSMS 22 may require the AD domain name or tenant ID, especially if you're a guest user from another Azure AD. You might want to fill in this information if you haven't already.

Verify User Profiles: Since the strange email address is a concern, check if there is an unintended profile or account setting. Sometimes, the application might pick up user information from a previous session or installation.

Update SSMS: Make sure that you're on the latest version of SSMS 22. Updates often come with bug fixes that might resolve your issue.

Review Connection Properties: Double-check the connection properties in SSMS when trying to connect, especially after the upgrade — some options may have been reset.

Check for Extensions: If any extensions or plugins are installed in SSMS, they might interfere with your connection settings. Try disabling them temporarily.

Let me know if these steps help resolve the issue!

I am not sure that this has anything to do with SSMS. You don't give the full chain of events, but since it says Verify Your Email, I would assume that some point you tried to log in and specified an email address, and this address is associated with the AOL address.

You may want to change the profile for that account. I believe account.microsoft.com would be the place to do that.