Microsoft KB Archive/301901

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

Article ID: 301901

Article Last Modified on 10/26/2007

-

APPLIES TO


 * Microsoft SQL Server OLAP Services
 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q301901



SUMMARY
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 &quot;Connecting Using HTTP&quot; topic in SQL Server Books Online.

Additional query words: TCP PORT FIREWALL HTTP OLAP

Keywords: kbproductlink kbinfo KB301901

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.