cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JanRambo Frequent Visitor
Frequent Visitor

Ports to be opened for On-Premise Gateway towards MS SQL

On top of the: https://community.powerbi.com/t5/Service/MS-SQL-server-timeout/m-p/375307#M41329

 

What ports should be opened between the On-Premise Gateway, which is installed on an app server, and MS SQL server based elsewhere?

 

Is 1433 sufficient?

 

Thanks a lot!

 

Jan

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Ports to be opened for On-Premise Gateway towards MS SQL

Hi @JanRambo.

 

For on premise gateway request ports, you can refer to below article:

On-premises data gateway

 

Spoiler

Ports

The gateway creates an outbound connection to Azure Service Bus. It communicates on outbound ports: TCP 443 (default), 5671, 5672, 9350 thru 9354. The gateway does not require inbound ports. Learn more

It is recommended that you whitelist the IP addresses, for your data region, in your firewall. You can download the Microsoft Azure Datacenter IP list. This list is updated weekly. The gateway will communicate with Azure Service Bus using the IP address along with the fully qualified domain name (FQDN). If you are forcing the gateway to communicate using HTTPS it will strictly use FQDN only, and no communication will happen using IP addresses.

Note

 

AFAIK, normally Sql server will use 1433 port, but I'm not so sure if your instances are modify to other ports.  Please double check on you database settings.

 

Regards,

Xiaxoin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
1 REPLY 1
Community Support Team
Community Support Team

Re: Ports to be opened for On-Premise Gateway towards MS SQL

Hi @JanRambo.

 

For on premise gateway request ports, you can refer to below article:

On-premises data gateway

 

Spoiler

Ports

The gateway creates an outbound connection to Azure Service Bus. It communicates on outbound ports: TCP 443 (default), 5671, 5672, 9350 thru 9354. The gateway does not require inbound ports. Learn more

It is recommended that you whitelist the IP addresses, for your data region, in your firewall. You can download the Microsoft Azure Datacenter IP list. This list is updated weekly. The gateway will communicate with Azure Service Bus using the IP address along with the fully qualified domain name (FQDN). If you are forcing the gateway to communicate using HTTPS it will strictly use FQDN only, and no communication will happen using IP addresses.

Note

 

AFAIK, normally Sql server will use 1433 port, but I'm not so sure if your instances are modify to other ports.  Please double check on you database settings.

 

Regards,

Xiaxoin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |