Unable to connect to Azure Database due to network settings/Firewall issue

Question

Hello,

I am an absolute beginner trying to start a simple project using Blazor and am trying to connect it to my SQL database but am getting this error:

A connection to the server 'xxxxxxx' could not be established. This might indicate an issue with your local firewall configuration or your network proxy settings.

I am not sure where to go from here. I found a similar post to this and tried things such as allowing access to port 1433 from this guide: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-windows-firewall-for-database-engine-access?view=sql-server-ver15#:~:text=To%20open%20a%20port%20in%20the%20Windows%20firewall%20for%20TCP%20access&text=In%20the%20Rule%20Type%20dialog,Click%20Next and also followed some info about changing stuff on the firewall in the azure portal but it seemed to not change anything.

This is the guide I was originally following to setup my project: https://www.youtube.com/watch?v=mR82ge6fd68

Any help would be appreciated.

Answer 1

Good day,

I found a similar post to this

This is absolutely NOT a similar scenario and not even a similar product. According to your description you are using Azure SQL database service while the link your provided is about SQL Server.

Using Azure Database you do not have any control in the server instance level or the operating system which host the instance. You only use a service of a logical instance. What you can and you should do is to configure the Azure firewall.

Check the following for more information on how to configure the Azure Firewall

https://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-configure

Answer 2

Something here may help you.

https://learn.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver15

--please don't forget to Accept as answer if the reply is helpful--

--------------------------

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.