Cleanup SQL logical server firewall rules#
Security · SQL Database · Rule · 2020_06 · Awareness
Determine if there is an excessive number of firewall rules.
Description#
Typically the number of firewall rules required is minimal, with management connectivity from on-premises and cloud application connectivity the most common.
Recommendation#
The logical SQL Server has greater then ten (10) firewall rules. Some rules may not be needed.
Links#
- SE:06 Network controls
- Azure SQL Database and Azure Synapse IP firewall rules
- Create and manage IP firewall rules
- Azure deployment reference