Microsoft KB Archive/841549

= How to enable ports on Windows XP SP2 for Analysis Services and SQL Server 7.0 OLAP Services =

Article ID: 841549

Article Last Modified on 3/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services
 * Microsoft SQL Server OLAP Services
 * Microsoft Windows XP Embedded

-





Beta Information
This article discusses a Beta release of a Microsoft product. The information in this article is provided as-is and is subject to change without notice.

No formal product support is available from Microsoft for this Beta product. For information about how to obtain support for a Beta release, see the documentation that is included with the Beta product files, or check the Web location where you downloaded the release.



INTRODUCTION
By default, Windows Firewall is enabled when you install Microsoft Windows XP Service Pack 2 (SP2). This article describes how to configure Windows Firewall in Windows XP SP2 to permit Microsoft SQL Server 2000 Analysis Services or SQL Server 7.0 OLAP Services to communicate by using the network.

Analysis Services
To enable Analysis Services, follow these steps:
 * 1) Click Start, click Run, type firewall.cpl, and then click OK.
 * 2) Click the Advanced Settings tab, click the Exceptions tab, and then click Add Port.
 * 3) In the Port Number dialog box, type 2725, and then click TCP.
 * 4) Type a name for the port, such as Analysis Services1, and then click OK.
 * 5) Click Add Port
 * 6) In the Port Number dialog box, type 2393, and then click TCP.
 * 7) Type a name for the port, such as Analysis Service2, and then click OK.
 * 8) Click Add Port
 * 9) In the Port Number dialog box, type 2394, and then click TCP.
 * 10) Type a name for the port, such as Analysis Services3, and then click OK.
 * 11) Click the Exceptions tab, and then click to select the check box that is next to each new service.
 * 12) Click OK

Note SQL Server 2000 uses port 2393 and port 2394 for backward compatibility with SQL Server 7 .0 clients (Pivot Table Services (PTS) version ). These ports do not have to be opened unless you must support SQL Server 7.0 client applications.

SQL Server 7.0 OLAP Services
To enable SQL Server 7.0 OLAP Services, follow these steps:
 * 1) Click Start, click Run, type firewall.cpl, and then click OK.
 * 2) Click the Advanced Settings tab, click the Exceptions tab, and then click Add Port.
 * 3) In the Port Number dialog box, type 2393, and then click TCP.
 * 4) Type a name for the port, such as OLAP1, and then click OK.
 * 5) In the Port Number dialog box, type 2394, and then click TCP.
 * 6) Type a name for the port, such as OLAP2, and then click OK.
 * 7) Click the Exceptions tab, and then click to select the check box that is next to each new service.
 * 8) Click OK.

Note If you disable the ports, you can click to clear the check box that is next to each new service.



MORE INFORMATION
If you send or receive data from the Web by using the Pivot Table Service (PTS) OLE DB provider, you must also open the required HTTP ports on the computer that is running Microsoft Internet Information Services (IIS). To enable these ports, follow these steps:
 * 1) Click Start, click Run, type firewall.cpl, and then click OK.
 * 2) In the Windows Firewall dialog box, click the Exceptions tab, and then click Add Port.
 * 3) In the Port Number dialog box, type 80, and then click TCP.
 * 4) Type a name for the port, such as HTTP, and then click OK.
 * 5) If you are using HTTPS, type 443 in the Port Number dialog box, and then click TCP.
 * 6) Type a name for the port, such as HTTPS, and then click OK.
 * 7) Click the Exceptions tab, and then click to select the check box that is next to each new service.
 * 8) Click OK.

Note If you are using the scenario that is described in the following white paper, you must open several ports:

http://msdn2.microsoft.com/en-us/library/aa902670(SQL.80).aspx

You must open the following TCP ports:
 * 135
 * 137
 * 138
 * 139
 * 445

