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

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 XXX). 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.

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: You must open the following TCP ports:

• 135
• 137
• 138
• 139
• 445

For additional information about how to configure Analysis Services or SQL Server 7.0 OLAP Services as exceptions on Windows Firewall, click the following article number to view the article in the Microsoft Knowledge Base: For additional information about how to configure SQL Server 2000 and Windows XP SP2, click the following article number to view the article in the Microsoft Knowledge Base: