Allowing Azure Service to Connect to your Azure SQL server
If you want your Azure SQL server to interact with your Azure services you need to update your firewall rule to "Allow Access to Other Azure Services" . This seems pretty straight forward and sensible BUT there is a major weakness regarding this setting that you must be aware of. Watch my video find out more