Other information
Customer managed Azure SQL
Firewall and Network Requirements for Azure SQL Database Access
3min
This document outlines the necessary network and firewall configurations required for accessing an Azure SQL database using Aimplan services. It includes key ports, protocols, and IP whitelisting instructions to ensure secure and seamless connectivity.
- Port and Protocol for Azure SQL Database:
- Default Port: Aimplan services will connect to the Azure SQL database using TCP on port 1433, which is the default for Azure SQL.
- Additional Ports: Azure may assign other ports as part of its optimization process. To accommodate this, it is recommended to allow the port range 11000-11999. This ensures connectivity in case Azure uses any ports within this range. More information can be found in the Azure SQL Ports Documentation.
- Whitelisting IP Addresses:
- All Aimplan services communicate through a single external gateway. The IP address 51.13.50.29 must be whitelisted to allow access to the Azure SQL database.
- During development, it may be necessary to whitelist additional IP addresses (e.g., office IPs) to enable database access from specific locations.
For scenarios involving Power BI, the following considerations apply:
- Power BI Service Access: If the "Allow Azure Services" option is not enabled in the Azure SQL configuration, a gateway must be set up to allow the Power BI Service to access the database. This ensures that Power BI can securely retrieve data from the database.
Updated 18 Oct 2024
Did this page help you?