How to enable SQL Server 2000 Reporting Services on Windows XP Service Pack 2

Article translations Article translations
Article ID: 841253 - View products that this article applies to.
Expand all | Collapse all

INTRODUCTION

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.

MORE INFORMATION

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.

REFERENCES

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

Properties

Article ID: 841253 - Last Review: August 13, 2004 - Revision: 2.2
APPLIES TO
  • Microsoft SQL Server 2000 Reporting Services
Keywords: 
kbhowto kbinfo KB841253

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com