Cmdlets

Choose a cmdlet from the list on the left or search for a specific cmdlet. Choose a cmdlet from the list or search for a specific cmdlet.
About Help  Providers
 

Set-AzureSqlDatabaseServerFirewallRule

Set-AzureSqlDatabaseServerFirewallRule

microsoft.windowsazure.commands.sqldatabase.dll

Synopsis

Updates the properties of an existing firewall rule in the specified Azure SQL Database Server.

Syntax

Set-AzureSqlDatabaseServerFirewallRule [-ServerName] [-RuleName] [-StartIpAddress] [-EndIpAddress] [-Force] [-WhatIf] [-Confirm] [<CommonParameters>]

Detailed Description

The Set-AzureSqlDatabaseServerFirewallRule cmdlet updates the start IP address and end IP address values of an existing firewall rule in the specified SQL Database Server.

Parameters

-ServerName <String>

Name of the SQL Database Server that contains the firewall rule to be updated. Specify only the server name, and not the fully qualified DNS name.

Aliases

None

Required?

true

Position

0

Default value

None

Accept pipeline input?

true (ByPropertyName)

Accept wildcard characters?

false

-RuleName <String>

Name of the SQL Database Server firewall rule to be updated.

Aliases

None

Required?

true

Position

named

Default value

None

Accept pipeline input?

true (ByPropertyName)

Accept wildcard characters?

false

-StartIpAddress <String>

The new start IP address value.

Aliases

None

Required?

true

Position

named

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-EndIpAddress <String>

The new end IP address value.

Aliases

None

Required?

true

Position

named

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-Force <SwitchParameter>

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

-WhatIf <SwitchParameter>

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

Aliases

None

Required?

false

Position

named

Default value

false

Accept pipeline input?

false

Accept wildcard characters?

false

-Confirm <SwitchParameter>

Prompts you for confirmation before running the cmdlet.

Aliases

None

Required?

false

Position

named

Default value

false

Accept pipeline input?

false

Accept wildcard characters?

false

Input Type

Microsoft.WindowsAzure.Commands.SqlDatabase.Model.SqlDatabaseServerFirewallRuleContext

Return Type

Microsoft.WindowsAzure.Commands.SqlDatabase.Model.SqlDatabaseServerFirewallRuleContext

Notes

Examples

-------------------------- Example 1 --------------------------

This command updates the start IP address and end IP address of the firewall rule (“myRule”) in the SQL Database Server (“lpqd0zbr8y”).

PS C:\> Set-AzureSqlDatabaseServerFirewallRule -ServerName "lpqd0zbr8y" -RuleName "myRule" -StartIpAddress 12.1.1.2 -EndIpAddress 12.1.1.4

Get-AzureSqlDatabaseServerFirewallRule
New-AzureSqlDatabaseServerFirewallRule
Remove-AzureSqlDatabaseServerFirewallRule