Troubleshooting: Signing into Azure SQL from SSMS with an Unknown Username

We Couldn’t Find an Account with That Username While Sign into Azure SQL from SSMS
Understanding the Problem
When trying to sign into Azure SQL from SSMS (SQL Server Management Studio), users may encounter the error message, “We couldn’t find an account with that username”. This can be confusing, as the username and password should be correct. It may be possible to work around the error by using an Azure Active Directory (AAD) account instead of a SQL Server login.

Root Cause of the Issue
The root cause of this issue is that the user is trying to sign in with a SQL Server login, rather than an Azure Active Directory account. If the user is using a SQL Server login, the username must match the domain name of the server or the Azure AD domain.

Resolving the Issue
To resolve this issue, users should use an Azure Active Directory account to sign into Azure SQL. An Azure AD account is required when connecting to Azure SQL to access a database in the cloud. To create an Azure AD account, users can log in to the Azure portal, select “Azure Active Directory”, and then “Users”. From there, they can create a new user.

Conclusion
The “We couldn’t find an account with that username” error can be confusing, as the username and password should be correct. However, this error occurs when the user is trying to sign in with a SQL Server login, rather than an Azure Active Directory account. To resolve this issue, users should use an Azure AD account to sign into Azure SQL. By following these steps, users can successfully sign into Azure SQL from SSMS.
References:
We couldn’t find an account with that username. While sign into Azure SQL from SSMS.
.

1. Azure SQL sign in
2. Azure SQL login
3.