Limit SQL logical server firewall rule range

Security · SQL Database · 2020_06

Determine if there is an excessive number of permitted IP addresses.

Description

Typically the number of IP address rules permitted through the firewall is minimal, with management connectivity from on-premises and cloud application connectivity the most common.

Recommendation

SQL Server has greater then ten (10) public IP addresses that are permitted network access. Some rules may not be needed or can be reduced.

Links

• Azure SQL Database and Azure Synapse IP firewall rules
• Create and manage IP firewall rules

---

Last update: 2021-07-04