| title | sys.firewall_rules (Azure SQL Database) | ||||
|---|---|---|---|---|---|
| description | Returns information about the server-level firewall settings associated with your Azure SQL Database. | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 08/28/2025 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | =azuresqldb-current |
[!INCLUDE Azure SQL Database]
Returns information about the server-level firewall settings associated with your [!INCLUDE ssazure-sqldb].
The sys.firewall_rules view contains the following columns:
| Column name | Data type | Description |
|---|---|---|
id |
int | The identifier of the server-level firewall setting. |
name |
nvarchar(128) | The name you chose to describe and distinguish the server-level firewall setting. |
start_ip_address |
varchar(45) | 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 [!INCLUDE ssSDS] server. The lowest possible IP address is 0.0.0.0. |
end_ip_address |
varchar(45) | 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 [!INCLUDE ssSDS] server. The highest possible IP address is 255.255.255.255.Note: Azure connection attempts are allowed when both this field and the start_ip_address field equals 0.0.0.0. |
create_date |
datetime | UTC date and time when the server-level firewall setting was created. Note: UTC is an acronym for Coordinated Universal Time. |
modify_date |
datetime | UTC date and time when the server-level firewall setting was last modified. |
To return information about the database-level firewall settings associated with your [!INCLUDE ssazure-sqldb], use sys.database_firewall_rules (Azure SQL Database).
Read-only access to this view is available to all users with permission to connect to the master database.
- sp_set_firewall_rule (Azure SQL Database)
- sp_delete_firewall_rule (Azure SQL Database)
- sp_set_database_firewall_rule (Azure SQL Database)
- sp_delete_database_firewall_rule (Azure SQL Database)
- sys.database_firewall_rules (Azure SQL Database)
- Configure Windows Firewall for Database Engine access
- Configure a Firewall for FILESTREAM Access
- Configure a firewall for report server access