Firewall exceptions for client IP

You can access the Datastore from the SQL Server Management Studio or any third-party tools from a client machine. However, the IP addresses of these client machines must be allowlisted to access the Datastore successfully. When you allowlist IP addresses, these addresses are considered as trusted addresses. You can define a single IP address or a range of IP addresses.

Allowlist a client IP address

Important: To allowlist reporting databases, ensure that the Reporting Analytics User role is assigned for the reporting database. To learn how to assign the Reporting Analytics User role, refer to Assign group and roles.

1. From the BI Gateway Model Builder Home Page, click in the upper right corner.

   A list with options appears. The current account is displayed.

   

2. Click Firewall exceptions for Client IP.

   The Firewall Rules dialog box appears.

   

3. Click +.

4. In the Firewall Rule Name box, type the name for the rule.

5. In the Start IP box, type the start IP address.

6. In the End IP box, type the end IP address range. This is the IP address at which the allowlisting ends.

   Note:
   - If you want to allowlist only one IP address, then enter the same IP address in the Start IP and End IP boxes. However, if you want to allowlist a range of IP addresses, enter the start IP address and end IP address range in the Start IP and End IP boxes.
   - We recommend that you do not allowlist the entire range of IP addresses from 0.0.0.0 to 255.255.255.255 to avoid any security risks.

7. Click Save.

   The selected IP addresses are allowlisted.

Edit an IP address

8. From the BI Gateway Model Builder Home Page, click in the upper right corner.

   A list with options appears.

9. Click Firewall exceptions for Client IP.

   The Firewall Rules dialog box appears with a list of the defined rules.

10. From the list of rules, edit the start and end IP addresses in the Start IP and End IP boxes, respectively, for the required rule.

11. Click Save.

    The selected IP addresses are allowlisted.

Delete an IP address

12. From the BI Gateway Model Builder Home Page, click in the upper right corner.

    A list with options appears.

13. Click Firewall exceptions for Client IP.

    The Firewall Rules dialog box appears with a list of the defined rules.

14. Click the icon in the row of the rule that you want to delete.

    The selected rule is deleted.