Azure / Azure/azure-powershell

Unable to remove Azure services access from DB server firewall

Open
#11,878 4 comments 0 reactions 0 assignees View on GitHub
act-codegen-extensibility-squad customer-reported question Service Attention SQL
Dominant language
C#
Stars
4.8k
Forks
4.3k
Avg merge
2d 17h
Merged PRs (30d)
51

Description

Hi,

using New-AzSqlServerFirewallRule -AllowAllAzureIPs you can enable the toggle to allow all Azure IP's to the database. I want to disable it, but there is no -AllowAllAzureIPs false and I cannot use Remove-AzSqlServerFirewallRule since that rule has no name

Contributor guide

Open the contributing guide

Research direction

Start by reviewing the New-AzSqlServerFirewallRule and Remove-AzSqlServerFirewallRule cmdlets and how the unnamed allow-all-Azure-IP rule is represented. The work is done when users can disable that setting without needing a rule name, with coverage for enabling and disabling it.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, powershell
Domain
cloud, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.