Aqua CSPM

SQL Server Firewall Rule Alerts Monitor

Quick Info

Plugin TitleSQL Server Firewall Rule Alerts Monitor
CloudAZURE
CategoryLog Alerts
DescriptionEnsures Activity Log Alerts for the create or update and delete SQL Server Firewall Rules events are enabled
More InfoMonitoring for create or update and delete SQL Server Firewall Rules events gives insight into event changes and may reduce the time it takes to detect suspicious activity.
AZURE Linkhttps://docs.microsoft.com/en-us/azure/sql-database/sql-database-firewall-configure
Recommended ActionAdd a new log alert to the Alerts service that monitors for SQL Server Firewall Rules create or update and delete events.

Detailed Remediation Steps

  1. Log into the Microsoft Azure Management Console.
  2. Select the “Search resources, services, and docs” option at the top and search for Alerts.
  3. On the “Alerts” page, click on the “Manage alert rules” at the top panel.
  4. On the “Rules” page, scroll down the page and check the “Target Resource Type” and check if there is any rules for “SQL Server Firewall Alerts”. If there is no “Alerts” configured then “Activity Log Alerts” for the create or update and delete “SQL Server Firewall Rules” events are not enabled.
  5. Repeat steps number 2 - 4 to check other Azure accounts.
  6. Navigate to the “Alerts” and click on the “New alert rule” at the top.
  7. On the “Create rule” page, click on the “Select” option under the “Resources” and search for “SQL Server” from the “Filter by resource type” and select the “Resource” accordingly.
  8. On the “Create rule” page, click on the “Add” option under the “Condition” and select “All Administrative operations” from the options and click on the “Done” option at the bottom of the tab.
  9. Under the “Actions”, select the “Action group” or “Create action group” accordingly.
  10. Enter the “Alert rule name” and “Description” under the “Alert Details” and click on the “Yes” button under the “Enable rule upon creation” to quickly enable the “SQL Server Firewall Rule Alerts”. Click on the “Create alert rule” button at the bottom to create a rule.
  11. Repeat steps number 6 - 10 to add a new log alert to the Alerts service that monitors for SQL Server Firewall Rules create or update and delete events.