question

D18-6874 avatar image
0 Votes"
D18-6874 asked pituach edited

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

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://docs.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-active-directoryazure-sql-databaseazure-firewall
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

pituach avatar image
0 Votes"
pituach answered pituach edited

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://docs.microsoft.com/en-us/azure/azure-sql/database/firewall-configure





· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yes, you are right, sorry for the misinformation.

I have followed that link prior to asking the question but it didn't seem to change anything. I configured the Azure firewall and added the client IP.

1 Vote 1 ·
DSPatrick avatar image
0 Votes"
DSPatrick answered

Something here may help you.

https://docs.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.






5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.