< Back
New-AzureRmSqlServerFirewallRule
Post
NAME New-AzureRmSqlServerFirewallRule
SYNOPSIS
Creates a firewall rule for a SQL Database server.
SYNTAX
New-AzureRmSqlServerFirewallRule [-ResourceGroupName] <String> [-ServerName] <String> [-AllowAllAzureIPs] [-DefaultProfile
<IAzureContextContainer>] [-Confirm] [-WhatIf] [<CommonParameters>]
New-AzureRmSqlServerFirewallRule [-ResourceGroupName] <String> [-ServerName] <String> [-DefaultProfile <IAzureContextContainer>] -EndIpAddress
<String> -FirewallRuleName <String> -StartIpAddress <String> [-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The New-AzureRmSqlServerFirewallRule cmdlet creates a firewall rule for the specified Azure SQL Database server.
PARAMETERS
-AllowAllAzureIPs [<SwitchParameter>]
Indicates that this firewall rule allows all Azure IP addresses to access the server. You cannot use this parameter if you intend to use the
FirewallRuleName , StartIpAddress , and EndIpAddress parameters. If you want to allow Azure IPs to access the server, this parameter should be
used in a separate cmdlet call that does not use the FirewallRuleName , StartIpAddress , and EndIpAddress parameters.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-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 new firewall rule.
Required? true
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of a 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 a server. Specify the server name, not the fully qualified DNS name.
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: Create a firewall rule
PS C:\\>New-AzureRmSqlServerFirewallRule -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -FirewallRuleName "Rule01" -StartIpAddress
"192.168.0.198" -EndIpAddress "192.168.0.199"
ResourceGroupName : ResourceGroup01
ServerName : Server01
StartIpAddress : 192.168.0.198
EndIpAddress : 192.168.0.199
FirewallRuleName : Rule01
This command creates a firewall rule named Rule01 on the server named Server01. The rule includes the specified start and end IP addresses.
Example 2: Create a firewall rule that allows all Azure IP addresses to access the server
PS C:\\>New-AzureRmSqlServerFirewallRule -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -AllowAllAzureIPs
This command creates a firewall rule on the server named Server01 that belongs to the resource group named ResourceGroup01. Since the
AllowAllAzureIPs parameter is used, the firewall rule allows all Azure IP addresses to access the server.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... rewallrule
Get-AzureRmSqlServerFirewallRule
Remove-AzureRmSqlServerFirewallRule
Set-AzureRmSqlServerFirewallRule
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/
SYNOPSIS
Creates a firewall rule for a SQL Database server.
SYNTAX
New-AzureRmSqlServerFirewallRule [-ResourceGroupName] <String> [-ServerName] <String> [-AllowAllAzureIPs] [-DefaultProfile
<IAzureContextContainer>] [-Confirm] [-WhatIf] [<CommonParameters>]
New-AzureRmSqlServerFirewallRule [-ResourceGroupName] <String> [-ServerName] <String> [-DefaultProfile <IAzureContextContainer>] -EndIpAddress
<String> -FirewallRuleName <String> -StartIpAddress <String> [-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The New-AzureRmSqlServerFirewallRule cmdlet creates a firewall rule for the specified Azure SQL Database server.
PARAMETERS
-AllowAllAzureIPs [<SwitchParameter>]
Indicates that this firewall rule allows all Azure IP addresses to access the server. You cannot use this parameter if you intend to use the
FirewallRuleName , StartIpAddress , and EndIpAddress parameters. If you want to allow Azure IPs to access the server, this parameter should be
used in a separate cmdlet call that does not use the FirewallRuleName , StartIpAddress , and EndIpAddress parameters.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-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 new firewall rule.
Required? true
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of a 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 a server. Specify the server name, not the fully qualified DNS name.
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: Create a firewall rule
PS C:\\>New-AzureRmSqlServerFirewallRule -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -FirewallRuleName "Rule01" -StartIpAddress
"192.168.0.198" -EndIpAddress "192.168.0.199"
ResourceGroupName : ResourceGroup01
ServerName : Server01
StartIpAddress : 192.168.0.198
EndIpAddress : 192.168.0.199
FirewallRuleName : Rule01
This command creates a firewall rule named Rule01 on the server named Server01. The rule includes the specified start and end IP addresses.
Example 2: Create a firewall rule that allows all Azure IP addresses to access the server
PS C:\\>New-AzureRmSqlServerFirewallRule -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -AllowAllAzureIPs
This command creates a firewall rule on the server named Server01 that belongs to the resource group named ResourceGroup01. Since the
AllowAllAzureIPs parameter is used, the firewall rule allows all Azure IP addresses to access the server.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... rewallrule
Get-AzureRmSqlServerFirewallRule
Remove-AzureRmSqlServerFirewallRule
Set-AzureRmSqlServerFirewallRule
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/