Set-AzureRmSqlServerFirewallRule
Syntax
Set-AzureRmSqlServerFirewallRule
[-ResourceGroupName] <String>
[-ServerName] <String>
[-FirewallRuleName] <String>
-EndIpAddress <String>
-StartIpAddress <String>
[-Confirm]
[-WhatIf]
[<CommonParameters>]
Description
The Set-AzureRmSqlServerFirewallRule cmdlet modifies a firewall rule in an Azure SQL Database server.
Examples
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.
Required Parameters
Specifies the end value of the IP address range for this rule.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Specifies the name of the firewall rule that this cmdlet modifies.
| Type: | String |
| Aliases: | Name |
| Position: | 2 |
| Default value: | None |
| Accept pipeline input: | True (ByPropertyName) |
| Accept wildcard characters: | False |
Specifies the name of the resource group to which the server is assigned.
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Accept pipeline input: | True (ByPropertyName) |
| Accept wildcard characters: | False |
Specifies the name of the server.
| Type: | String |
| Position: | 1 |
| Default value: | None |
| Accept pipeline input: | True (ByPropertyName) |
| Accept wildcard characters: | False |
Specifies the start value of the IP address range for the firewall rule.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Optional Parameters
Prompts you for confirmation before running the cmdlet.
| Type: | SwitchParameter |
| Aliases: | cf |
| Position: | Named |
| Default value: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Shows what would happen if the cmdlet runs. The cmdlet is not run.
| Type: | SwitchParameter |
| Aliases: | wi |
| Position: | Named |
| Default value: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Outputs
Microsoft.Azure.Commands.Sql.FirewallRule.Model.AzureSqlServerFirewallRuleModel