Forum Discussion
Ports needed to connect On-premises data gateway with Azure SQL server
Hi borys864
Thank you for reaching Microsoft forum community.
As per your query which Ports needed to connect On-premises data gateway with Azure SQL server
To enable communication between the On-premises data gateway and your Azure SQL server when it is behind a VNET and not publicly exposed, you need to ensure that the appropriate network ports are open for the On-premises data gateway to connect to the Azure SQL server.
Below are the key ports you need to open:
- TCP port 1433: This is the default port used by SQL Server, including Azure SQL Database. You'll need this port to be open between the On-premises data gateway and the Azure SQL server.
- TCP port 443: This port is used for HTTPS communication with the Power BI service. The On-premises data gateway needs to communicate with Power BI over HTTPS, and this port is essential for the gateway to interact with Power BI and send data securely.
If this post clears your issue, please give us Kudos and consider marking Accepting it as a solution to guide other members in finding it more easily.
v-saisrao-msft so between on-prem gateway and azure sql servier only one, 1433 port is needed?
Thank you for your answer. As mentioned before on-prem gateway setup with power bi is already in place.
Community SupportHi borys864
We greatly appreciate your efforts and addressing your concerns. Here is the breakdown of your points:
As you mentioned, the 1433 port is necessary between the on-prem gateway and Azure SQL Server because it facilitates communication with the Azure SQL Database.