Azure SQL Database
An Azure relational database service.
6,252 questions
Login failed for user '<token-identified principal>'.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 66%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Thomas
0
Reputation points
Hi, I am suddenly experiencing issues trying to use the query editor preview where it is throwing up this error. I cannot seem to access anything.
Microsoft Entra authentication
Login failed for user '<token-identified principal>'.
Continue as username (with red X)
Any advice you could offer? Was working fine a couple weeks ago. Really appreciate any help. thanks!
Azure SQL Database
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 95%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Saraswathi Devadula 3,155 Reputation points Microsoft External Staff Moderator2025-04-30T09:36:47.1433333+00:00 Hello Thomas
I kindly request you to please share the details requested in the private message for further investigation, which will help us to mitigate this issue.
-
Nandan Hegde 35,271 Reputation points MVP Moderator2025-04-30T17:47:25.5366667+00:00 Can you even try accessing the same server via SSMS once and confirm whether the issues is same? And can you confirm whether the account still has access within the database?
-
Alberto Morillo 34,656 Reputation points MVP Moderator2025-04-30T19:02:36.22+00:00 I have seen that when using a VPN. If you examine the Azure SQL firewall you may notice that the IP address listed to add to the firewall is not the one assigned to your computer by the VPN. That is the reason.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 0%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Alejandro Delgado 0 Reputation points2025-05-01T07:22:33.77+00:00 I am Thomas's colleague. I am not using any VPN and firewalls are properly setup but we cannot still access.
Due to this we are not able to run our application and this is a critical issue that we need to solve as we have client demos scheduled for next week.
-
Saraswathi Devadula 3,155 Reputation points Microsoft External Staff Moderator
2025-05-01T07:36:00.8133333+00:00 Hello Thomas, Alejandro Delgado
Following our discussion over the remote session, you are unable to connect to the database using entra authentication in the query editor.
As informed, I am working internally on this request to get it resolved as soon as possible.
Appreciate your time and patience.
Sign in to comment
Sign in to answer