INF: TCP Ports Used by OLAP Services when Connecting Through a Firewall

Article translations Article translations
Article ID: 301901 - View products that this article applies to.
This article was previously published under Q301901
Expand all | Collapse all


Firewalls are frequently used for security, and many firewalls are set to disable the TCP ports that are used by Microsoft Analysis Services 2000 and Microsoft OLAP Services 7.0. Consequently, when you deploy OLAP Services clients over an intranet, extranet or internet, you should consider the TCP ports that are used by both the server and the client.


OLAP Services 7.0 uses TCP ports 2393 and 2394. Microsoft has also reserved UDP ports 2393 and 2394; however, UDP ports 2393 and 2394 are not used by OLAP Services. Analysis Services uses TCP port 2725. For backward compatibility, Analysis Services uses TCP ports 2393 and 2394 when connected with an OLAP Services 7.0 client.

Connections that use HTTP were introduced with Analysis Services. This connection method allows the PivotTable® Service to tunnel through firewalls or proxy servers to the Analysis Services server. When connecting to Analysis Services by using HTTP, the connection occurs through Microsoft Internet Information Services (IIS). The port used during connection is defined by the default port of the Web site. In most cases, the default port of the Web site is set to 80 (or 443 if Secure Sockets Layer [SSL] is used).

For additional information about connecting to Analysis Services 8.0 by using an HTTP connection, refer to the "Connecting Using HTTP" topic in SQL Server Books Online.


Article ID: 301901 - Last Review: October 26, 2007 - Revision: 3.4
  • Microsoft SQL Server OLAP Services
  • Microsoft SQL Server 2000 Analysis Services
kbproductlink kbinfo KB301901

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from