SQL Server Firewall Rules

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

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.
    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.
    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.
    Add Firewall Rule button
    The Firewall Rule pop-up window opens.
    Firewall Rule pop-up
  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 Edit button for the Rule Name you want to edit.
    Edit button
    The Firewall Rule pop-up window opens.
    Firewall Rule pop-up
  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 Delete button for the Rule Name you want to delete.
    Delete button
    The Delete Firewall Rule pop-up window opens.
    Delete Firewall Rule pop-up
  2. Click Delete.
Was this article helpful?
0 out of 0 found this helpful
Previous Next

Comments

0 comments

Please sign in to leave a comment.