i am trying to simply export BACPAC file from azure db to azure blob storage
as mentioned here : https://docs.microsoft.com/en-us/azure/azure-sql/database/database-export
but it is failed with error :
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.
what's the cause of this error i am not sure, do you think i have to enable allow all azure service checkbox in azure db firewall? ( before i took backup and i was not doing this step)
also wanted to mention that both resource azure blob and azure db are in private virtual network.
also i am scared of this : https://www.fmsinc.com/microsoft-azure/sql-server/security.htm