Set-AzureRmSqlServerVirtualNetworkRule

NAME Set-AzureRmSqlServerVirtualNetworkRule



SYNOPSIS

Modifies the configuration of an Azure SQL Server Virtual Network Rule.





SYNTAX

Set-AzureRmSqlServerVirtualNetworkRule [-ResourceGroupName] <String> [-AsJob] [-DefaultProfile <IAzureContextContainer>]

[-IgnoreMissingVnetServiceEndpoint] -ServerName <String> -VirtualNetworkRuleName <String> -VirtualNetworkSubnetId <String> [-Confirm] [-WhatIf]

[<CommonParameters>]





DESCRIPTION

This command modifies the configuration of an Azure SQL Server Virtual Network Rule.





To control the set of virtual network rules in the server, use 'Add-AzureRmSqlServerVirtualNetworkRule' and

'Remove-AzureRmSqlServerVirtualNetworkRule' instead.







PARAMETERS

-AsJob [<SwitchParameter>]

Run cmdlet in the background



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



-IgnoreMissingVnetServiceEndpoint [<SwitchParameter>]

Create firewall rule before the virtual network has vnet service endpoint enabled.



Required? false

Position? named

Default value False

Accept pipeline input? False

Accept wildcard characters? false



-ResourceGroupName <String>

The name of the resource group.



Required? true

Position? 0

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ServerName <String>

The Azure Sql Server name.



Required? true

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-VirtualNetworkRuleName <String>

The name of the Azure Sql Server Virtual Network Rule.



Required? true

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-VirtualNetworkSubnetId <String>

The Virtual Network Subnet Id for the 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

System.String







OUTPUTS

Microsoft.Azure.Commands.Sql.VirtualNetworkRule.Model.AzureSqlServerVirtualNetworkRuleModel







NOTES









Example 1



PS C:\\> $virtualNetworkRule = Set-AzureRmSqlServerVirtualNetworkRule -ResourceGroupName rg -ServerName serverName -VirtualNetworkRuleName

virtualNetworkRuleName -VirtualNetworkSubnetId virtualNetworkSubnetId



Modifies an existing virtual network rule with the new virtual network subnet id which contains information about the new virtual network







RELATED LINKS

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