Can not connect to Azure Db when web server behind Proxy ServerRSS

2 replies

Last post Mar 14, 2019 09:06 AM by Nadir Husain

  • Can not connect to Azure Db when web server behind Proxy Server

    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?

  • Re: Can not connect to Azure Db when web server behind Proxy Server

    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

    Regards,

    Jalpa.

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue.
    If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
  • Re: Can not connect to Azure Db when web server behind Proxy Server

    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 internet.
    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.

    Thanks,

    Nadir