We couldn't find an account with that username. While sign into Azure SQL from SSMS.
Published Feb 09 2023 03:03 AM 4,308 Views
Microsoft

Issue

Sometime users when get to sign in to azure during some operations like backup/restore or managing failover gets an error on signing page says ‘We couldn't find an account with that username. Try another or get a new Microsoft account.’

 

AhmadNassar_0-1675940078388.png

 

Investigation/Analysis

After checking with the user his SSMS configuration and Options we found changes in Azure cloud name which led to changes in resource management URLs and those URLs act as the endpoints for authenticating the user accounts against Azure active directory. And this caused the error as the user account not found in this Azure cloud offering.

 

AhmadNassar_1-1675940120590.png

 

Mitigation and workaround

In order to mitigate the issue user need to change the Azure cloud name to ‘AzureCloud’ as this is the common offering for all users

 

AhmadNassar_2-1675940149744.png

 

After that the user will be able to find his account and pick it to sign in

 

AhmadNassar_3-1675940176456.png

 

Co-Authors
Version history
Last update:
‎Feb 09 2023 03:03 AM
Updated by: