Microsoft small business knowledge base

Article ID: 841253 - Last Review: January 17, 2015 - Revision: 2.2

This article has been archived. It is offered "as is" and will no longer be updated.


This article describes how to enable Microsoft SQL Server 2000 Reporting Services on computers that are running Microsoft Windows XP Service Pack 2. You must configure Windows Firewall to allow Reporting Services network connectivity. By default, Windows Firewall is enabled.


You can access Reporting Services locally or remotely. If you are accessing Reporting Services locally, you do not have to make any changes to Windows Firewall. If you are accessing Reporting Services remotely, through a browser or through an application, you must enable Reporting Services by opening certain required ports on Windows Firewall.

For Reporting Services, you must enable ports for HTTP and for HTTPS access, if you are using HTTPS.

Note Port 80 is the default port setting for Reporting Services.

If you are not sure if you are using the default port setting, follow these steps:
  1. Open Control Panel, and then click Administrative Tools.
  2. Click Internet Information Services, right-click the Reporting Services Web site, and then click Properties. The port that Reporting Services is using is listed in the TCP Port box.
To enable Reporting Services on Windows XP Service Pack 2, follow these steps:
  1. Click Start, and then click Run.
  2. In the Run dialog box, type Firewall.cpl, and then click OK.
  3. In the Windows Firewall dialog box, click the Exceptions tab, and then click Add Port.
  4. In the Add a Port dialog box, type Your port number in the Port number box, and then click the TCP button.
  5. Type a name for the port, such as HTTP, and then click OK.
  6. If you are using HTTPS, type 443 in the Port Number box, and then click the TCP button.
  7. Type a name for the port, such as HTTPS, and then click OK.
  8. On the Exceptions tab, you will see the new Service. To enable the port, click to select the check box next to your new service.
  9. Click OK.

If you later decide to disable these ports, you can clear the check box next to your new service.

Note If you are accessing the Reporting Services Windows Management Instrumentation (WMI) provider remotely, you must enable port 135.


For additional information about configuring SQL Server 2000 and Windows XP Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
841249  ( ) How to configure Windows XP Service Pack 2 (S) for use with SQL Server

  • Microsoft SQL Server 2000 Reporting Services
kbnosurvey kbarchive kbhowto kbinfo KB841253
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