Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Which Power BI ports should be open in Windows Firewall for SQL SERVER for database access.

Which ports should be open in Windows Firewall for Prod DB Server's db access, currently am trying to connect databases from PowerBI Gateway (i.e. dataset), it refuses connection for prod machines but successfully connect uat db server. Firewall is enabled in prod server whereas it is disabled on uat server.

I blv it is something related to firewall setting.
any help in this regard.

Need Help
  • ibarrau's avatar
    ibarrau
    3 years ago

    Hi. It definitely sounds like a network issue. I'm not sure it's that but let me tell you that by default, the typical ports used by SQL Server and associated database engine services are: TCP 1433, 4022, 135, 1434, UDP 1434.

    I hope that helps,

1 Reply

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    3 years ago

    Hi. It definitely sounds like a network issue. I'm not sure it's that but let me tell you that by default, the typical ports used by SQL Server and associated database engine services are: TCP 1433, 4022, 135, 1434, UDP 1434.

    I hope that helps,