SQL Server firewall rules - az sql server firewall-rule

Manage a server's firewall rules.

Commands

az sql server firewall-rule create Creates a firewall rule.
az sql server firewall-rule delete Deletes a firewall rule.
az sql server firewall-rule list Lists the firewall rules.
az sql server firewall-rule show Shows the detail of a firewall rule.
az sql server firewall-rule update Updates a firewall rule.

az sql server firewall-rule create

Creates a firewall rule.

az sql server firewall-rule create --end-ip-address
--name
--resource-group
--server
--start-ip-address

Required Parameters

--end-ip-address

The end IP address of the firewall rule. Must be IPv4 format. Use value '0.0.0.0' to represent all Azure-internal IP addresses.

--name -n

The name of the firewall rule.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=.

--server -s

The name of the Azure SQL server.

--start-ip-address

The start IP address of the firewall rule. Must be IPv4 format. Use value '0.0.0.0' to represent all Azure-internal IP addresses.

az sql server firewall-rule delete

Deletes a firewall rule.

az sql server firewall-rule delete --name
--resource-group
--server

Required Parameters

--name -n

The name of the firewall rule.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=.

--server -s

The name of the Azure SQL server.

az sql server firewall-rule list

Lists the firewall rules.

az sql server firewall-rule list --resource-group
--server

Required Parameters

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=.

--server -s

The name of the Azure SQL server.

az sql server firewall-rule show

Shows the detail of a firewall rule.

az sql server firewall-rule show --name
--resource-group
--server

Required Parameters

--name -n

The name of the firewall rule.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=.

--server -s

The name of the Azure SQL server.

az sql server firewall-rule update

Updates a firewall rule.

az sql server firewall-rule update --name
--resource-group
--server
[--end-ip-address]
[--start-ip-address]

Required Parameters

--name -n

The name of the firewall rule.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=.

--server -s

The name of the Azure SQL server.

Optional Parameters

--end-ip-address

The end IP address of the firewall rule. Must be IPv4 format. Use value '0.0.0.0' to represent all Azure-internal IP addresses.

--start-ip-address

The start IP address of the firewall rule. Must be IPv4 format. Use value '0.0.0.0' to represent all Azure-internal IP addresses.