Set-AzureRmSqlServerFirewallRule

NAME Set-AzureRmSqlServerFirewallRule



SYNOPSIS

Modifies a firewall rule in Azure SQL Database server.





SYNTAX

Set-AzureRmSqlServerFirewallRule [-ResourceGroupName] <String> [-ServerName] <String> [-FirewallRuleName] <String> [-DefaultProfile

<IAzureContextContainer>] -EndIpAddress <String> -StartIpAddress <String> [-Confirm] [-WhatIf] [<CommonParameters>]





DESCRIPTION

The Set-AzureRmSqlServerFirewallRule cmdlet modifies a firewall rule in an Azure SQL Database server.





PARAMETERS

-DefaultProfile <IAzureContextContainer>

The credentials, account, tenant, and subscription used for communication with azure



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-EndIpAddress <String>

Specifies the end value of the IP address range for this rule.



Required? true

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-FirewallRuleName <String>

Specifies the name of the firewall rule that this cmdlet modifies.



Required? true

Position? 2

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ResourceGroupName <String>

Specifies the name of the resource group to which the server is assigned.



Required? true

Position? 0

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ServerName <String>

Specifies the name of the server.



Required? true

Position? 1

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-StartIpAddress <String>

Specifies the start value of the IP address range for the firewall rule.



Required? true

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-Confirm [<SwitchParameter>]

Prompts you for confirmation before running the cmdlet.



Required? false

Position? named

Default value False

Accept pipeline input? False

Accept wildcard characters? false



-WhatIf [<SwitchParameter>]

Shows what would happen if the cmdlet runs. The cmdlet is not run.



Required? false

Position? named

Default value False

Accept pipeline input? False

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).



INPUTS

None

This cmdlet does not accept any input.





OUTPUTS

Microsoft.Azure.Commands.Sql.FirewallRule.Model.AzureSqlServerFirewallRuleModel







NOTES









Example 1: Modify a firewall rule



PS C:\\>Set-AzureRmSqlServerFirewallRule -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -FirewallRuleName "Rule01" -StartIpAddress

"192.168.0.197" -EndIpAddress "192.168.0.199"

ResourceGroupName : ResourceGroup01

ServerName : Server01

StartIpAddress : 192.168.0.199

EndIpAddress : 192.168.0.200

FirewallRuleName : Rule01



This command modifies a firewall rule named Rule01 on the server named Server01. The command modifies the start and end IP addresses.







RELATED LINKS

Online Version: https://docs.microsoft.com/en-us/powers ... rewallrule

Get-AzureRmSqlServerFirewallRule

New-AzureRmSqlServerFirewallRule

Remove-AzureRmSqlServerFirewallRule

SQL Database Documentation https://docs.microsoft.com/azure/sql-database/