token-identified principal login failed

Antonio Krsnik 21 Reputation points

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

    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


1 additional answer

Sort by: Most helpful
  1. Alberto Morillo 32,886 Reputation points MVP


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

    Hope this helps.