sql-serverazurepowershellfirewallazure-cli

How to enable "Allow Azure services and resources to access this server" through PowerShell (Azure CLI)?


After creating a new Azure SQL server using az sql server create, how can I enable the following options through PowerShell(Azure CLI)?

enter image description here


Solution

  • It's in the documentation for Azure SQL somewhere, if you search for "azure sql firewall allow azure services", but here's what you need to do - create a rule with a start and end address of 0.0.0.0, like this:

    az sql server firewall-rule create --resource-group <resource group name> --server <azure sql name> -n <any name> --start-ip-address 0.0.0.0 --end-ip-address 0.0.0.0