Help and Support
 

powered byLive Search

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

Article ID:301901
Last Review:October 26, 2007
Revision:3.4
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 "Connecting Using HTTP" topic in SQL Server Books Online.

APPLIES TO
Microsoft SQL Server OLAP Services
Microsoft SQL Server 2000 Analysis Services

Back to the top

Keywords: 
kbproductlink kbinfo KB301901

Article Translations

 

Other Support Options

  • Need More Help?
    Contact a Support professional by E-mail, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.