IIS 7 and Above
Application Request Routing (ARR)
Can not connect to Azure Db when web server behind Proxy Server
Last post Mar 14, 2019 09:06 AM by Nadir Husain
Mar 13, 2019 11:33 AM|Nadir Husain|LINK
Unable to connect/forward database connection request to Azure SQL server when the web server is behind a proxy server. Web server is successful in connecting to the Queue storage on Azure at port 443 through the Proxy server but the SQL Server connection
at port 1433 does not get routed to the Proxy server. Any Suggestions would be helpful?
Mar 14, 2019 02:17 AM|Jalpa Panchal|LINK
Hi Nadir Husain,
Firewall systems help prevent unauthorized access to computer resources. If a firewall is turned on but not correctly configured, attempts to connect to SQL Server might be blocked.
To access an instance of the SQL Server through a firewall, you must configure the firewall on the computer that is running SQL Server.
Try to configure firewall to allow access sql server port 1433.
You could refer below article:
Configure the Windows Firewall to Allow SQL Server Access
Mar 14, 2019 09:06 AM|Nadir Husain|LINK
Hi Jalpan Panchal,
The database is hosted on Azure. Also the web server(IIS) is behind a proxy server so any connection request to an external network have to go through the proxy server. The Database connection request isn't forwarded or reaches the proxy server to reach the
The windows firewall on the web server is temporarily turned of for testing purpose. And the IP addresses for the databases are also configured on the network firewall.