New-AzureSqlDatabaseServerFirewallRule
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
New-AzureSqlDatabaseServerFirewallRule
Creates a new firewall rule in the specified SQL Database server in the current subscription.
Syntax
Parameter Set: IpRange
New-AzureSqlDatabaseServerFirewallRule [-ServerName] <String> -EndIpAddress <String> -RuleName <String> -StartIpAddress <String> [-Force] [-Confirm] [-WhatIf] [ <CommonParameters>]
Detailed Description
The New-AzureSqlDatabaseServerFirewallRule cmdlet creates a new firewall rule in the specified SQL Database server. Any IP address within the range specified in the StartIpAddress and EndIpAddress parameters will be able to connect to the SQL Database server. A firewall rule with starting and ending IP addresses equal to 0.0.0.0 indicates that Windows Azure connections to this SQL Database server are allowed.
Parameters
-EndIpAddress<String>
End value of the IP address range.
Aliases |
none |
Required? |
true |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-Force
Allows the action to complete without prompting you for confirmation.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-RuleName<String>
New SQL Database firewall rule name.
Aliases |
none |
Required? |
true |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-ServerName<String>
The name of the SQL Database server where the new firewall rule is created. Specify only the server name, and not the fully qualified DNS name.
Aliases |
none |
Required? |
true |
Position? |
1 |
Default Value |
none |
Accept Pipeline Input? |
True (ByPropertyName) |
Accept Wildcard Characters? |
false |
-StartIpAddress<String>
Start value of the IP address range.
Aliases |
none |
Required? |
true |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-Confirm
Prompts you for confirmation before executing the command.
Required? |
false |
Position? |
named |
Default Value |
|
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-WhatIf
Describes what would happen if you executed the command without actually executing the command.
Required? |
false |
Position? |
named |
Default Value |
|
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
<CommonParameters>
This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see about_CommonParameters
Inputs
The input type is the type of the objects that you can pipe to the cmdlet.
Outputs
The output type is the type of the objects that the cmdlet emits.
- SqlDatabaseServerFirewallRuleContext
Examples
-------------- Example 1 --------------
This command creates a new firewall rule (“myRule”) in the specified SQL Database server (“lpqd0zbr8y”).
PS C:\> New-AzureSqlDatabaseServerFirewallRule –ServerName "lpqd0zbr8y" -RuleName "myRule" -StartIpAddress 12.1.1.1 –EndIpAddress 12.1.1.2
Related topics
Get-AzureSqlDatabaseServerFirewallRule