Azure Entra ID Authentication fails on Azure APP Services

21887231 0 Microsoft Vendor

On Local applicaitons we are able to validate connection Server=tcp:XXXXX.database.windows.net,1433;Initial Catalog=demo;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;Authentication=Active Directory Default;

Once deployed in azure same application its throwing 500 error. Can you help me here please

Erland Sommarskog 109.5K Reputation points MVP

2024-07-10T21:05:01.0866667+00:00

500 is a an error number from a web server, so I am not sure what this has to do with SQL Server. You need to debug your app to see why it produces error 500. If this is related to the connection to SQL Server, you need to find the error message produced the client API.
Sai Raghunadh M 75 Reputation points Microsoft Vendor

2024-08-26T06:19:55.5866667+00:00

Hi @21887231,
Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Sai Raghunadh M 75 Reputation points Microsoft Vendor

2024-08-23T05:22:49.4533333+00:00
Hi @21887231,

Thanks for the question and using MS Q&A platform

If you're having trouble with Azure Entra ID authentication on Azure App Services, there are a few things you can check to troubleshoot the issue:

Check that the settings you're using for Entra ID authentication in your application match the settings you used when testing the application locally. This includes the tenant ID, client ID, and client secret.

Check that your database firewall settings allow your application to connect to it. You can do this by going to your database in the Azure portal and clicking on "Firewalls and virtual networks" under the "Security" section.

Check the logs for your application to see if there are any error messages or other information that can help you identify the issue. You can access the logs for your application in the Azure portal by going to your App Service and clicking on "Log stream" under the "Monitoring" section.

Make sure that your App Service is running on a plan that supports Entra ID authentication. Not all App Service plans support this feature, so you may need to upgrade your plan if you're experiencing issues.

Hope this helps. Do let us know if you have any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful.
Please sign in to rate this answer.
Sai Raghunadh M 75 Reputation points Microsoft Vendor

2024-08-27T05:46:28.98+00:00

Hi @21887231, Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Sign in to comment

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

Your answer