token-identified principal login failed

Antonio Krsnik 21 Reputation points
2022-01-25T20:03:31.21+00:00

I am trying to get familiar with Azure and I want to use my free account to work on my SQL skills.
I created a server and database and I added AD group to it. I am the only one that is using this so I am the owner. However when I want to try to connect server (Azure Active Directory - Universal with MFA) with SSMS I am getting Login failed for user <token-identified principal> error. Same happens on Query Editor in the portal I don't have possibility to "reset password" of the server admin and I do not know which Active directory admin I need to select (I can't select my Microsoft account)

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee
    2022-01-26T17:08:59.617+00:00

    Hi, @Antonio Krsnik Welcome to Microsoft Q&A, Thanks for posting your question.
    Can you please provide the error screenshot, can you also please confirm if you have followed all the configuration steps

    Regards
    Geetha


1 additional answer

Sort by: Most helpful
  1. Alberto Morillo 32,886 Reputation points MVP
    2022-01-26T20:16:08.873+00:00

    Antonio,

    Let us know if this troubleshooting article helps you solve the issue.

    Hope this helps.