When you deploy to azure, if you deploy a SQL resource and get the error:

  
Resource: <sqlserver>/allowAllWindowsAzureIps
  
Type: Microsoft.Sql/servers/firewallrules
  
Deployment operation: /subscriptions/<sub>/resourceGroups/<rg>/deployments/<step>-wbutzq/operations/7F08CAF6B8F791D1<br /> Status: NotFound<br /> Provisioning State: Failed<br /> Status Message: "{\r\n \"code\": \"NotFound\",\r\n \"message\": \"\",\r\n \"target\": null,\r\n \"details\": [],\r\n \"innererror\": []\r\n}"<br />

</p>

Then you need to:

* Edit the SQL firewall settings
* disable "Allow All Azure IPs"
* re-provision