How can we add multiple IP addresses to the firewall rules on Azure SQL Server?

Question

How can we add multiple IP addresses or IP address in CIDR to the firewall rules on Azure SQL Server?

Answer 1

@Nikhil Thanks for posting your question in the Microsoft Q&A forum.

To add a firewall rule for an IP address range in CIDR notation, you can use the New-AzSqlServerFirewallRule cmdlet with the -StartIpAddress and -EndIpAddress parameters set to the same IP address in the range. Here is an example command that adds a firewall rule for an IP address range:

New-AzSqlServerFirewallRule -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 adds a firewall rule for the IP address range You can modify the IP address range as needed to match your requirements.

Regards

Geetha

Answer 2

Hi,

You can convert CIDR to desired start IP and End IP and create rule(s) as needed. For example, say you wanted to allow 52.253.200.0/24, you could enter 52.253.200.1 for Start IP and 52.253.200.254 for End IP.

There are many free online subnet calculation tools if you don't want to do it manually.

If above was helpful please click Accept Answer. If you need more assistance please add comment.

Thanks.

-TP