@Oury Ba-MSFT - I am also facing same issue and the SSMS version - v18.9.1
Login failed for user '<token-identified principal>'. (Microsoft SQL Server, Error: 18456) in a group but works when the user is added directly
MrFlinstone
686
Reputation points
I get the error Login failed for user '<token-identified principal>'. (Microsoft SQL Server, Error: 18456) from Azure SQL server when a user tries to login using Azure Active Directory - Universal with MFA.
My Azure AD login is within a group, other members of the group can login to the database, but I get the error '<token-identified principal>'. (Microsoft SQL Server, Error: 18456), however If the user is added to the database, then I can login and it works.
create user [******@contoso.com] from external provider
GO
EXEC sp_addrolemember N'db_datareader', N'******@contoso.com'
I was wondering if there is a reason for this.
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions