Azure SQL DB Service

Question

I am not able to open Azure SQL DB service says that Firewall blocked using office corporate network.

Prathap Reddy · Answer

Allow the IP address for this server. And update the Firewall rules.Additionally, if you are working from office get the admin rights for your system and do the nessasary firewall updation in to your system .

Cr Bhargavi · Answer

If you are unable to access an Azure SQL Database from your office corporate network due to firewall restriction, Please Verify the firewall rules configured for your Azure SQL Database. You can do this through the Azure portal or by using Azure CLI or Azure PowerShell. Ensure that the corporate network's public IP address or IP range is added to the allowed IP list and even if that didnt work out, Reach out to your network administrator or IT support team in your office and inform them about the issue. They might be able to help you by either whitelisting the necessary IP addresses or configuring a proxy server to access the Azure SQL Database.

Mohamed Azarudeen Z · Answer

Hi jana If you are not able to access your Azure SQL Database from your office corporate network, it is likely that the network administrator has blocked access to the database server through the corporate firewall. To resolve this issue, you need to ask your network administrator to open up the firewall rules for your Azure SQL Database. They can do this by adding your office network's IP address range to the firewall's allowed list. To find the IP address range for your office network, you can use an online IP address lookup tool, such as https://www.whatismyip.com/. Once you have the IP address range, you can provide it to your network administrator to add it to the Azure SQL Database firewall rules. If you are still unable to access the database even after adding the IP address range to the firewall rules, you can try connecting to the database from a different network or using a VPN connection to bypass the corporate firewall. I hope this helps. Let me know if you have any further questions.

Vishal Yelve · Answer

Hi Janarthanan, you need to set server firewall To set a server-level IP firewall rule from the database overview page, select Set server firewall on the toolbar, refer below link https://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-configure?view=azuresql https://www.c-sharpcorner.com/article/creating-an-azure-sql-database/

Saravanan Ganesan · Answer

Hi Jana , If you are unable to access Azure SQL Database and receive a firewall error while using your office corporate network, it is likely that the outbound traffic to the Azure SQL Database is blocked by the corporate firewall. To resolve this issue, you can take the following steps: Check Firewall Rules: Contact your IT or network administrator to confirm if there are any specific firewall rules in place that might be blocking access to Azure SQL Database from your office network. If so, request them to modify the rules to allow outbound connections to the necessary Azure SQL Database endpoints. Whitelist IP Addresses: Azure SQL Database allows you to configure firewall rules that specify the IP addresses or ranges that are allowed to access the database. Ensure that your office network's public IP address is added to the firewall rules of the Azure SQL Database. Use Virtual Network Service Endpoints (Preview): If your organization uses Azure Virtual Network, you can enable Virtual Network Service Endpoints for Azure SQL Database. This allows you to access the database securely over a private endpoint within the virtual network, bypassing the public internet and potential firewall restrictions. Use VPN or ExpressRoute: If your organization has a VPN or Azure ExpressRoute connection to Azure, you can route your database traffic through these private connections, bypassing the public internet and corporate firewall altogether. Test from Different Network: To confirm that the issue is related to your corporate network's firewall, try accessing the Azure SQL Database from a different network, such as your home network or a mobile hotspot. If the connection works from the alternate network, it further indicates that the corporate firewall is causing the issue. Contact Azure Support: If you have tried the above steps and are still unable to resolve the issue, consider reaching out to Azure Support for further assistance.

Azure SQL DB Service

Answers (5)