Azure SQL Firewall

[ravz]

Hello, what is the bicep equivalent for setting the 'Allow Azure services and resources to access this server` option under SQL server firewall ?

[brwilkinson]

https://docs.microsoft.com/en-us/azure/templates/microsoft.sql/2021-08-01-preview/servers/firewallrules?tabs=bicep

I believe it should be below:

https://github.com/brwilkinson/AzureDeploymentFramework/blob/main/ADF/bicep/AZSQL-SQL.bicep#L51

resource SQLAllowAllWindowsAzureIps 'Microsoft.Sql/servers/firewallRules@2020-11-01-preview' = {
  name: 'AllowAllWindowsAzureIps'
  parent: SQL
  properties: {
    startIpAddress: '0.0.0.0'
    endIpAddress: '0.0.0.0'
  }
}

resource SQLAllConnectionsAllowed 'Microsoft.Sql/servers/firewallRules@2020-11-01-preview' = {
  name: 'AllConnectionsAllowed'
  parent: SQL
  properties: {
    startIpAddress: '0.0.0.0'
    endIpAddress: '255.255.255.255'
  }
}

[brwilkinson]

hi @ravz just a ping on this answer.

[robjdav]

Hello - just wondering how you would turn off the FW option for Azure services without disabling the FW completely?

I've looked at an exported ARM template for this scenario and the 'AllowAllWindowsAzureIps' config is missing

thanks

Rob