Azure SQL connect to Azure storage for selected network

116 views Asked by At

I have created connectivity from Azure SQL to Azure storage .

  1. Create master key
  2. Created scoped CREDENTIAL
  3. Created External data source

connecting azure storage when Azure storage when Azure firewall selected All networks . If I change Selected network (attached screen shot) then connectivity not working . Please note my IP address already whitelisted .

Any suggestion how I can enable firewall and access storage from Azure Sql

enter image description here

1

There are 1 answers

2
Leon Yue On

If you choose the selected networks for Storage firewall, you need to use the IP address to the control the access from client.

This operation is same with Azure SQL database firewall.

Please could add the client IP and click the Allow trusted Microsoft services to access this storage account:

enter image description here

HTH,