How to enable SQL Server 2000 Analysis Services and OLAP Services on computers that are running Windows XP SP2 (841256)


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

INTRODUCTION

By default, Microsoft Windows Firewall is enabled on computers that are running Microsoft Windows XP Service Pack 2 (SP2). Windows Firewall closes ports, such as 445, that are used for file and printer sharing. Windows Firewall does this to prevent Internet computers from connecting to file shares and print shares on your computer or on other resources. When Microsoft SQL Server is configured to listen for incoming client connections by using Named Pipes over a NetBIOS session, SQL Server communicates over TCP ports. The TCP ports must be open. Therefore, SQL Server 2000 Analysis Services cannot connect until you set Analysis Services as an exception in Windows Firewall. To do this, follow these steps:
  1. Click Start, click Run, type firewall.cpl, and then click OK.
  2. Click the Exceptions tab, and then click Add Program.
  3. In the Add Program dialog box, click SQL Server Analysis Services or locate the program that you want to add to the exceptions.

    Note By default, Analysis Services is located in C:\Program files\Microsoft Analysis Services\BIN\msmdsrv.exe.
  4. Locate your installation of Analysis Services, click Msmdsrv.exe, and then click OK.
  5. Click the Exceptions tab, make sure that the exception is listed, and then click OK.

MORE INFORMATION

If you send or receive data from the Web by using the Pivot Table Service (PTS) OLE DB provider, you must open the required HTTP ports on the computer that is running Microsoft Internet Information Services (IIS). To do this, 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 your new service.
  8. Click OK.
Note If you use the scenario that is described in the following white paper, you must manually open the required TCP ports:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_datapump.asp

For additional information about how to manually set the ports that are required for Analysis Services or OLAP clients, click the following article number to view the article in the Microsoft Knowledge Base:

841549 How to enable ports on Windows XP S for SQL Server 2000 Analysis Services and OLAP

REFERENCES

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:MajorLast Reviewed:8/11/2004
Keywords:kbhowto kbinfo KB841256 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.