question

MarcoPagan-9564 avatar image
1 Vote"
MarcoPagan-9564 asked NavtejSaini-MSFT answered

Azure SQL Server firewall not allowing operation to connect even though option is set to yes in firewall settings

I am trying to import my local SQL server database into Azure & I have all the requirements (storage, bacpac file, etc). When I try to import the db, I am getting the error below.

The Azure SQL Server firewall did not allow the operation to connect. To resolve this, please select the "Allow All Azure" checkbox in the Sql Server's configuration blade.

I have already checked yes on the Allow Azure services and resources to access this server option in the firewall settings. Is there something behind the scenes preventing it from allowing access? I am running my SQL server on a Docker container. My Client IP is in my firewall settings along with an IP that is from 0.0.0.0 to 255.255.255.255 and the database still will not import.

Imported bacpac file
81936-local-db.png

Import Operation Azure
81860-import-azure.png

Import Error
81837-import-error.png

Firewall Settings
81918-firewall-settings.png


azure-sql-databaseazure-migrateazure-firewallazure-database-migration
local-db.png (233.6 KiB)
import-error.png (108.2 KiB)
import-azure.png (128.7 KiB)
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.

1 Answer

NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered

@MarcoPagan-9564

We see that you were able to resolve the issue here on Stack Overflowcand as mentioned below:

It might have been the cache on Azure's side. I got in contact with an Azure rep recently and they stated that the cache may have not updated yet. Clearing your cache could be the source of the problem as well.

Creating a new rule that spans from 0.0.0.0 to 255.255.255.255 in your firewall settings.

Regards
Navtej S


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.