Azure SQL Public IPs – Microsoft Q&A

As per learn.microsoft.com/en-us/azure/azure-sql/database/firewall-configure?view=azuresql

The maximum number of server-level IP firewall rules is limited to 256 for a server.

As per learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-set-firewall-rule-azure-sql-database?view=azuresqldb-current , a single rule can consist of a single range of consecutive IP addresses.

If the above response helps answer your question, remember to “Accept Answer” so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin