How to find the Azure Firewall Setting Allowing Access is the solution to HTTP Error 500, Site is unable to handle this request Error?

krishna572 876 Reputation points
2022-04-13T03:01:28.433+00:00

This is regarding the previous question follow-up:
https://learn.microsoft.com/en-us/answers/questions/810439/http-error-500-unable-to-handle-this-request.html

As I'm new to Azure So unaware of Firewall settings and it is not mentioned in the YouTube Course Video so asking this question.

When I looked into diagnostics, it shown me these where it doesn't contain any clue about Azure SQL Database Firewall setting needs to be allowed for the Azure Services:

rleGrnw.png
PQOIen2.png

Azure SQL Database
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,179 questions
{count} vote

Accepted answer
  1. Alberto Morillo 33,251 Reputation points MVP
    2022-04-13T10:53:40.073+00:00

    The "internal server error - 500" indicates that the server crashed while serving the request. It's a generic error, so lots of things could be going on. However, this error 500 is unusual if the database is set up properly.

    My suggestion is to download the log files as explained on the documentation (using Azure Storage Explorer - free tool) and whe you examine the logs you may find there messages related to unable to connect to the database or login failed errors when connecting to Azure SQL. In that case always verify 3 things:

    • Ensure that you have a SQL database created properly - it should be listed as a Connection String in the Application Settings for your App Service.
    • The firewall settings on Azure SQL database
    • The proper login name and password is used to connect to the database.
    0 comments No comments

0 additional answers

Sort by: Most helpful