Blog Post

Azure Database Support Blog
3 MIN READ

AAD Auth Error - Login failed for user '<token-identified principal>'

FonsecaSergio's avatar
FonsecaSergio
Icon for Microsoft rankMicrosoft
May 26, 2020
An error may appear when trying to login to Azure SQL DB using AAD authentication   =================================== Cannot connect to SERVENAME.database.windows.net. =======================...
Updated Aug 11, 2023
Version 4.0
azuresqldb
Connectivity
MrGalvan's avatar
MrGalvan
Copper Contributor
Mar 03, 2021

Xiao_Wu - 

what caused my issue was the user was dropped and recreated, so the Object ID in Azure was incorrect. This is what caused the Login failed for user '<token-identified principal>' error message I was receiving. 

 

This same user was also an admin on the sql instance in Azure. So, I had to remove that user as an admin and re-add that same user as the admin. 

 

Once I did that, my problem was resolved.