Delete lock prevents editing of IP address in Azure Sql Server firewall

LXX 1 Reputation point
2022-05-19T20:59:00.66+00:00

We are unable to edit IP addresses in Azure Sql Server firewall whilst a delete lock is in place.

Some of our staff do not have static IP addresses so have to regularly update their IP addresses in the firewall. The only way to do this is to first remove the delete lock, which defeats the purpose of the lock!

It should be possible to perform an edit without having to remove delete lock, however, it looks like the edit function is actually doing a DELETE + CREATE instead of UPDATE.

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,377 Reputation points Microsoft Employee
    2022-05-19T23:16:38.703+00:00

    Hi, @LXX Welcome to the Microsoft Q&A forum, and thanks for reaching out.
    Sorry for the inconvenience caused, This is a known issue that we are in process of fixing it.
    As for now, here are the workarounds that are a little bit easier to use.

    1. Add a new firewall rule with a new name. And remove old ones when the overall amount of rules reaches close to 128
    2. Use PowerShell/CLI to update firewall rules Set-AzSqlServerFirewallRule (Az.Sql) | Microsoft Learn
    3. Use T-SQL to update firewall rules on master DB IP firewall rules - Azure SQL Database and Azure Synapse Analytics | Microsoft Learn

    Please let me know if the information is helpful

    Regards
    Geetha

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.