Azure CLI - Whitelist IP for SQL Server

*Source: *

az sql server firewall-rule [update/add/create]

Example

$myip = (Get-NetIPAddress -AddressFamily IPV4 -InterfaceAlias Wi-Fi).IPAddress
$myip2 = (Invoke-WebRequest -uri "https://api.ipify.org/").Content

$name = "Jimmy"

az sql server firewall-rule update --end-ip-address $myip --start-ip-address $myip -g AS-RESERVE -s reserving-modernization -n $name
az sql server firewall-rule update --end-ip-address $myip2 --start-ip-address $myip -g AS-RESERVE -s reserving-modernization -n "Jimmy2"


az sql server firewall-rule update --end-ip-address $myip --start-ip-address $myip -g AS-RESERVE -s reserving-modernization -n $name
az sql server firewall-rule add --end-ip-address $myip --start-ip-address $myip -g AS-RESERVE -s reserving-modernization -n $name
az sql server firewall-rule --help
az sql server firewall-rule create --end-ip-address $myip --start-ip-address $myip -g AS-RESERVE -s reserving-modernization -n $name

---

Appendix: Links

• Code
• Development

Backlinks:

list from [[Azure CLI - Whitelist IP for SQL Server]] AND -"Changelog"