Policy: Azure > SQL > Server > Firewall > IP Ranges > Approved > IP Addresses

Configure SQL server to allow access from specific internet IP addresses. This configuration grants access to specific internet-based services and on-premises networks, and blocks general internet traffic.

Provide allowed internet IP addresses in the form of individual startIpAddress and endIpAddress like in the below example.

Example: - startIpAddress: 203.0.113.5
endIpAddress: 203.0.113.5

Resource Types

This policy targets the following resource types:

Azure > SQL > Server

Primary Policy

This policy is used with the following primary policy:

Azure > SQL > Server > Firewall > IP Ranges > Approved

Controls

Policy Specification

Schema Type	`array`
Default	`[]`
Examples [YAML]	`- startIpAddress: 203.0.113.5 endIpAddress: 203.0.113.5`

In Your Workspace

Policy Settings by Type report

Developers

Category URI

tmod:@turbot/turbot#/control/categories/resourceApproved

Policy Type URI

tmod:@turbot/azure-sql#/policy/types/serverFirewallIpRangesApprovedIpAddresses

GraphQL

query policyType(id: "tmod:@turbot/azure-sql#/policy/types/serverFirewallIpRangesApprovedIpAddresses") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/azure-sql#/policy/types/serverFirewallIpRangesApprovedIpAddresses'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/azure-sql#/policy/types/serverFirewallIpRangesApprovedIpAddresses'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/azure-sql#/policy/types/serverFirewallIpRangesApprovedIpAddresses"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/azure-sql#/policy/types/serverFirewallIpRangesApprovedIpAddresses"