Clear-CafAllSqlFirewallRules

Removes all custom firewall rules currently added to the SQL server given with regard to resource group locks.

Syntax

Clear-CafAllSqlFirewallRules
    [-AzureSqlServerName <string>]
    [-TenantId <string>]

Description

Removes all firewall rules currently added to the SQL server given. Any nodelete lock on the parent resource group will be de- and re-activated automatically using the service principals. You do net need elevated privileges for this. The rule to allow Azure resources accessing the server will not be affected by this.

Example

Clear-CafAllSqlFirewallRules -AzureSqlServerName mySQLServerName

Parameter

- AzureSqlServerName
The name of the SQL server.

Property	Value
Type:	string
Default value:	None
Required:	False

- TenantId
The unique ID of the tenant where the subscription lives in for faster context switch.

Property	Value
Type:	string
Default value:	None
Required:	False