Azure Web App timeout pulling from SQL even though Hybrid Connection says Connected

Question

Hi, we have published a website via azure web app which pulls data from an azure-hosted SQL database, we're using a Hybrid Connection which says "connected" but when viewing the website none of the SQL data pulls through - just times out.

Answer 1

Hi @MS54321

Thanks for your patience. How did you configure your hybrid connection and connection string? did you check the Application Event Logs to get more info on errors or exceptions?

Since your status says Connected but your app cannot reach your endpoint then double check the following:

• Make sure you're using a DNS name in your Hybrid Connection. If you use an IP address then the required client DNS lookup may not happen. If the client running in your web app doesn't do a DNS lookup, then the Hybrid Connection will not work
• Check that the DNS name used in your Hybrid Connection can resolve from the HCM host. Check the resolution using nslookup EndpointDNSname where EndpointDNSname is an exact match to what is used in your Hybrid Connection definition
• Test access from your HCM host to your endpoint using the PowerShell command Test-NetConnection EndpointDNSname -P Port. If you cannot reach the endpoint from your HCM host then check firewalls between the two hosts including any host-based firewalls on the destination host
• If you're using App Service on Linux, make sure you're not using "localhost" as your endpoint host. Instead, use your machine name if you're trying to create a connection with a resource on your local machine

Hope this helps! Please us know if you have any other questions.

-Grace