Unable to login with Entra Authentication SQL Database Query Editor

Luciano Moura 0

User's image

I need to login using Entra Authentication to create other Active Directory users.

1 answer

Alberto Morillo 34,041 Reputation points MVP

2024-02-07T01:51:44.54+00:00

Did you follow the instructions provided on this documentation? This a common error as you can read here. Make sure you made all the required configurations and the [Entra user is created](https://learn.microsoft.com/en-us/answers/questions/1031697/azure-app-container-to-azure-sql-login-failed-(tok) on the Azure SQL Database. You should also add your public IP address to the Azure SQL firewall whitelist.
Please sign in to rate this answer.
Luciano Moura 0 Reputation points

2024-02-07T13:19:47.4833333+00:00

The microsoft entra admin is already configured. now I just need to add my IP to the firewall white list?

Alberto Morillo 34,041 Reputation points MVP

2024-02-07T15:09:12.74+00:00

Here is the documentation to manage Azure SQL firewall.

Oury Ba-MSFT 19,506 Reputation points Microsoft Employee

2024-02-07T22:09:54.6+00:00

Luciano Moura Thank you for reaching out. Please don't forget to mark as accept answer if the reply from @Alberto Morillo helped. Regards, Oury

Oury Ba-MSFT 19,506 Reputation points Microsoft Employee

2024-02-12T17:33:35.1766667+00:00

Luciano Moura Still facing issues.? Please do let us know the result. Regards, Oury

Oury Ba-MSFT 19,506 Reputation points Microsoft Employee

2024-02-14T00:01:41.34+00:00

Luciano Moura Checking if you were able to manage to firewall. Please let me know if you need further assistance or if the issue is resolved. Regards, Oury

Jerghiuta, Dan 31 Reputation points

2024-06-14T15:15:46.9966667+00:00

Did something change recently? I used to have access to the database via Entra ID group membership. Do I need now to also add my ID to the database?

Also regarding IP addresses - I have an IP address assigned by VPN, but the Query Editor appears to have a different IP. Where is that coming from?

Jerghiuta, Dan 31 Reputation points

2024-06-14T15:19:14.9033333+00:00

I have the same problem, but until recently I was able to query the database.

I noticed that the IP address listed to add to the firewall is not the one assigned to my computer by VPN. Where is that IP address coming from?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Unable to login with Entra Authentication SQL Database Query Editor

1 answer

Your answer