DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 841256 - Last Review: March 20, 2007 - Revision: 2.5

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://msdn2.microsoft.com/en-us/library/aa902670(SQL.80).aspx (http://msdn2.microsoft.com/en-us/library/aa902670(SQL.80).aspx)
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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/841249/ ) How to configure Windows XP Service Pack 2 for use with SQL Server

APPLIES TO
  • Microsoft SQL Server 2000 Analysis Services
  • Microsoft SQL Server OLAP Services
  • Windows XP Embedded
Keywords: 
kbhowto kbinfo KB841256
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support