Forum Discussion
Ports needed to connect On-premises data gateway with Azure SQL server
Dear community
We are planning to run our Azure SQL server and access it in Power BI SaaS using On-premises data gateway.
Power BI and On-premises data gateway are already setup and are servicing a number of on-prem SQL servers but now we want to try Azure SQL server. Due to restrictions our Azure SQL server is not publicly exposed and it we plan to put it behind VNET and only allow access to it from On-premises data gateway. Now question is what ports we need to open between On-premises data gateway and Azure SQL server?
Internally we have a vnet peering from on-prem to Azure but I need to know what ports are required for successful On-premises data gateway connection towards 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.
5 Replies
v-saisrao-msftCommunity Support
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.
- v-saisrao-msft
Hi 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.
- GilbertQ
Super User
Hi borys864
Here is a way to configure access to azure sql server. VNET Data Gateway for Microsoft Power BI and SQL Server. | by Dileepa Mabulage | Medium
I explicitly stated that we have On-premises data gateway. At the moment usage of PowerBI VNet Data Gateway is not an option.
