Login failed for user '<token-identified principal>'. (Microsoft SQL Server, Error: 18456) in a group but works when the user is added directly

MrFlinstone 406 Reputation points
2022-06-28T21:24:14.747+00:00

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 [myUserName@contoso.com] from external provider  
    GO  
    EXEC sp_addrolemember N'db_datareader', N'myUserName@contoso.com'  

I was wondering if there is a reason for this.

Azure SQL Database
1 vote

1 answer

Sort by: Most helpful
  1. naveen G kumar 1 Reputation point
    2022-11-22T04:48:45.95+00:00

    @Oury Ba-MSFT - I am also facing same issue and the SSMS version - v18.9.1