Share via

Azure SQL Public IPs

Jeff Fazio 36 Reputation points
2024-07-19T01:47:34.42+00:00

I am trying to find if there is a maximum number of Public IPs I can add to the firewall rules to allow access in Azure SQL?

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Marcin Policht 24,630 Reputation points MVP
    2024-07-19T03:34:08.6+00:00

    As per https://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 https://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

    0 comments

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.