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 and added my client IP. Is there something behind the scenes preventing it from allowing access? I am running my SQL server on a Docker container.

[![Local DB Azure Data Studio imported bacpac file][1]][1]

https://stackoverflow.com/questions/66738798/azure-sql-server-firewall-not-allowing-operation-to-connect-even-though-option-i March 22, 2021 at 07:53AM