Admin: Corporate Admin
Page: Tools > Developer Tools > SQL Server Firewall Rules
URL: [CLIENTID].corpadmin.directscale.com/Corporate/Admin/AzureResourceManagement/SqlServerFirewallRules
Permission: ViewAdministration(), EditSqlDatabaseFirewallRules()

The SQL Server Firewall Rules page allows you to create Firewall Rules at a Database Level in order to grant a developer access to your database. This page also displays a list of both Server and Database Level rules to show which allowlisted IP addresses have access to which server or database. 

Allowlisting Your IP Address

The Add My IP feature allows you to allowlist your own IP address. 

To allowlist your IP address:

1. Click the Add My IP button.

   

   You cannot enter a Rule Name or manually enter an IP address upon creation.

2. A confirmation message will appear to confirm the Database Level Rule was successfully added to the Firewall Rules List.

   

Creating Database Level Rules

The Add Firewall Rule feature allows you to create a new Firewall Rule by entering a Rule Name and allowlisting an IP address range.

To create a new Firewall Rule:

1. Click the Add Firewall Rule button.

   

   The Firewall Rule pop-up window opens.

   

2. Enter a Rule Name.
3. Enter an IP address or range in the Start IP Address and End IP Address fields.

   When entering an IP address range, the range must not include more than 255 IP addresses.

4. Click Save.

Editing Database Level Rules

To modify an existing Database Level Rule:

1. Click the button for the Rule Name you want to edit.

   

   The Firewall Rule pop-up window opens.

   

2. Edit the Start IP Address and End IP Address fields as necessary.

   The Rule Name cannot be edited.

3. Click Save.

Deleting Database Level Rules

To remove an existing Database Level Rule:

1. Click the button for the Rule Name you want to delete.

   

   The Delete Firewall Rule pop-up window opens.

   

2. Click Delete.