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


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.

More Information

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.