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


The information in this article applies to:

  • Microsoft SQL Server 2000 Analysis Services
  • Microsoft SQL Server OLAP Services 7.0
  • the operating system: Microsoft Windows XP SP2

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

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://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_datapump.asp

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

REFERENCES

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:

841256 How to enable SQL Server 2000 Analysis Services and OLAP on computers that are running Windows XP Service Pack 2

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:

841249 How to configure Windows XP Service Pack 2 for use with SQL Server

Modification Type:MinorLast Reviewed:11/17/2004
Keywords:kbinfo KB841549 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.