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

D18 26 Reputation points
2020-06-09T19:33:54.11+00:00

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.

Azure SQL Database
Azure Firewall
Azure Firewall
An Azure network security service that is used to protect Azure Virtual Network resources.
567 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,473 questions
0 comments
Accepted answer
  1. Ronen Ariely 15,096 Reputation points
    2020-06-09T19:54:09.203+00:00

    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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426.1K Reputation points MVP
    2020-06-09T19:42:29.44+00:00

    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.

    0 comments