sys.firewall_rules (Azure SQL Database)

 

THIS TOPIC APPLIES TO: noSQL Server yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns information about the server-level firewall settings associated with your Microsoft Azure SQL Database.

The sys.firewall_rules view contains the following columns:

Column nameData typeDescription
idINTThe identifier of the server-level firewall setting.
nameNVARCHAR(128)The name you chose to describe and distinguish the server-level firewall setting.
start_ip_addressVARCHAR(50)The lowest IP address in the range of the server-level firewall setting. IP addresses equal to or greater than this can attempt to connect to the SQL Database server. The lowest possible IP address is 0.0.0.0.
end_ip_addressVARCHAR(50)The highest IP address in the range of the server-level firewall setting. IP addresses equal to or less than this can attempt to connect to the SQL Database server. The highest possible IP address is 255.255.255.255.

Note: Windows Azure connection attempts are allowed when both this field and the start_ip_address field equals 0.0.0.0.
create_dateDATETIMEUTC date and time when the server-level firewall setting was created.

Note: UTC is an acronym for Coordinated Universal Time.
modify_dateDATETIMEUTC date and time when the server-level firewall setting was last modified.

To remove a database firewall rule, use sp_delete_firewall_rule (Azure SQL Database). To set a firewall rule for a single database, see sys.database_firewall_rules (Azure SQL Database). To return information about existing firewall rules, query sys.firewall_rules (Azure SQL Database).

Read-only access to this view is available to all users with permission to connect to the master database.

sys.database_firewall_rules (Azure SQL Database)
sp_set_firewall_rule (Azure SQL Database)
Configure a Windows Firewall for Database Engine Access
Configure a Firewall for FILESTREAM Access
Configure a Firewall for Report Server Access
How to: Configure Firewall Settings (Azure SQL Database)

Community Additions

ADD
Show: