Article ID: 841256 - View products that this article applies to.
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:
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:
http://msdn2.microsoft.com/en-us/library/aa902670(SQL.80).aspxFor 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:
(http://support.microsoft.com/kb/841549/ )How to enable ports on Windows XP S for SQL Server 2000 Analysis Services and OLAP
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:
(http://support.microsoft.com/kb/841249/ )How to configure Windows XP Service Pack 2 for use with SQL Server
Contact us for more help
Connect with Answer Desk for expert help.