Export (0) Print
Expand All

Software Requirements for Reporting Services

SQL Server 2000

This topic identifies the software prerequisites and requirements for each Reporting Services component. Prerequisites are items that must be installed or configured on the computer that the components are being installed on in order for setup to run without error. These prerequisites are shown in the Setup wizard.

Required software components are additional software components that should be installed on the computer, but the absence of which will not cause setup to fail. However, their absence may cause features to not be available for installation, or features to not work after setup has completed. You can configure the computer after setup has finished to get the features to work.

For example, during installation, you can select the report server to use Secure Sockets Layer (SSL). Setup checks to see if an SSL certificate is present on the computer. If it is not, you will receive a message indicating that SSL is not available. You must either install SSL and continue with the installation, or select to not use SSL at this time and later configure the report server for this feature. These system requirements and prerequisites are verified and displayed to you on the System Requirements Check dialog.

Setup Prerequisites

The following prerequisites are required by Setup.

Distributed Transaction Coordinator Service

Setup requires the Microsoft Distributed Transaction Coordinator (MS DTC) service. Before you run setup, verify that the startup type for the service is set to Automatic or Manual. To view service state, point to Administrative Tools in Control Panel and click Services. To change the startup type, right-click Distributed Transaction Coordinator, and then click Properties.

Installation points

You can run setup from the product CD-ROM, from a file share expressed in Universal Naming Convention (UNC) format, or from a local folder. You cannot run setup from a mapped drive to a network share.

Component Setup Requirements

The following table lists the components of Reporting Services, and the required software and configuration settings on the computer before a given component is installed.

Component Prerequisites
Report server Web server with ASP.NET and Internet Information Services (IIS) 5.0 or higher.

MDAC 2.6 or higher.

Connection to SQL Server 2000 SP3a instance.

Default Web site accessible through http://<servername>.

For Windows 2003, the computer must be configured as an application server.

For Windows 2003 to use the network service account to run the ReportServer service, you need SQL Server QFE 859. To download the QFE, go to Microsoft Support. Note that after you install the hotfix, you cannot rename columns in Enterprise Manager. Consider using a different account if you do not want to apply the hotfix.

Report Manager Web server with ASP.NET.

IIS 5.0 or later installed and configured.

Default website accessible through http://<servername>.

Report server database Server with SQL Server 2000 SP3a.
Report Designer Client workstation with Microsoft Visual Studio® .NET 2003 or another product that provides the Visual Studio 2003 shell (such as Visual Basic .NET 2003 or Visual C# .NET 2003) and MDAC 2.6 or higher.
Administrative tools and utilities Client workstation with access to a report server.
Reporting Services Books Online Client workstation, no prerequisites.
Sample reports and applications Client workstation, no prerequisites.

If you need to install the MDAC 2.6 prerequisite, you can download MDAC from Data Access Downloads. System requirements and installation instructions are available with the download.

The following table associates the various Reporting Services editions with the client or server components available on each operating system.

Edition Components Operating system
Evaluation Edition Server or client Win2000 with SP4, all editions.

Windows 2003, all editions.

Standard Edition Server Windows 2000 Server with SP4 or later.

Windows 2000 Advanced Server with SP4 or later.

Windows 2000 Datacenter Server with SP4 or later.

Windows Server 2003, Standard Edition, Enterprise Edition, or Datacenter Edition.

Standard Edition Client Windows 2000, SP4 or later.

Windows XP Professional with SP1 or later.

Enterprise Edition Server Windows 2000 Server with SP4 or later.

Windows 2000 Advanced Server with SP4 or later.

Windows 2000 Datacenter Server with SP4 or later.

Windows Server 2003, Standard Edition, Enterprise Edition, or Datacenter Edition..

Enterprise Edition, client components only Client Windows 2000, SP4 or later.

Windows XP Professional with SP1 or later.

Developer Edition Server or Client Windows XP Professional with SP1 or later.

Win2000 with SP4, all editions.

Windows 2003, all editions.

General Requirements

This section lists the software components that are required for some features to function. They should be installed on the computer that the Reporting Services components are being installed on, but their absence does not cause Setup to fail. However, their absence may cause features to not be available for installation, or features to not work after Setup has completed.

Secure Sockets Layer

If you want to use Secure Sockets Layer (SSL) to secure data on your reports, an SSL certificate must be installed on the machine and associated with the default web site on the machine that will be hosting the report server. Installing report server fails if the checkbox regarding the use of SSL on the Reporting Services Virtual Directories dialog is checked, but an SSL certificate is not installed on the machine that is hosting the report server and associated with the default web site. You can configure report server to use SSL for requests that contain sensitive data either during Setup (SSL checkbox) or in the configuration file (SecureConnectionLevel property).

If you configure the report server to use SSL during Setup, the certificate must be installed and associated with the Default web site in IIS. Setup also checks the value of the Require Secure Channel (SSL) checkbox, which is located in the Directory Security tab of the Default web site properties page. If the Require Secure Channel (SSL) checkbox is checked, then the configuration element SecureConnectionLevel is set to 3, which is the most secure and restrictive level. Otherwise, the value of the SecureConnectionLevel element is set to 2.

If, after Setup is run, the Require Secure Channel (SSL) checkbox is checked, the configuration file element SecureConnectionLevel is not modified from 2 to 3. You must manually change the value. For more information on how to change the SecureConnectionLevel in the configuration file, see Using Secure Web Service Methods.

Other Requirements

For viewing reports, users generally access reports and manage the report server through a Web browser. There are no minimum operating system requirements for viewing published reports, except that the browser used to access the reports must support HTML 3.2. For the browser used to access and manage a report server using Report Manager, the client computer must have Microsoft Internet Explorer 6.0 with Service Pack 1 (SP1), with scripting enabled. For more information about browsers and their use in viewing reports and managing reports, see Browser Types Supported by Reporting Services.

Edition Compatibility

Not all editions of Reporting Services can create a report server database on all editions of SQL Server 2000 SP3a. Setup determines whether the SQL Server edition can support a report server database, based on the following table.

Edition of Reporting Services Valid edition of SQL Server
Standard Standard, Enterprise
Enterprise Standard, Enterprise
Developer Standard, Enterprise, Developer
Evaluation Standard, Enterprise, Developer, Evaluation

Component Update

When installing Reporting Services, several components need to be installed or updated in order for the installation to run correctly. The Component Update dialog of the Setup wizard lists the features that will be installed or updated. The components that are installed or updated may be one or more of the following:

  • Windows Installer 2.0
  • Microsoft .NET Framework version 1.1
  • Microsoft SQL Server 2000 Reporting Services Setup Support Files

Once these components have been installed, they cannot be uninstalled or rolled back by Setup.

See Also

Editions of Reporting Services

Introducing Reporting Services

Hardware Requirements for Reporting Services

Preparing to Install

Choosing the Reporting Services Installation Method

Reporting Services Component Overview

Selecting Components of Reporting Services to Install

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft