NIB - How to: Install Reporting Services on a Single Computer

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

Use these procedures to install the complete set of client and server components on a single computer. In addition to client and server components, these instructions also include steps for installing the Database Engine, used for hosting the report server database and necessary for installing the report server in default configuration mode.

These instructions assume that you are installing Reporting Services in the default configuration on a computer that does not have a previous installation. If you are upgrading or reinstalling, you might not be able to use the default configuration installation option. In this case, you must choose the Install but do not configure the server option and then run the Reporting Services Configuration tool and the Surface Area Configuration tool after Setup is complete to finish configuring the report server. For more information, see NIB - How to: Install a Local Report Server and Remote Report Server Database and Upgrade (Reporting Services).

Install client and server components on a single computer

  1. Verify that IIS is installed and ASP.NET is enabled.

  2. To begin the installation process, insert the SQL Server DVD into your DVD drive and launch splash.hta.

  3. Click Run the SQL Server Installation Wizard. Read and then accept the licensing terms and conditions.Click Next to install the prerequisites.

  4. Click Next on the Welcome Screen.

  5. Click Next on the Prerequisite Check. If IIS and ASP.NET are not enabled on the computer, cancel Setup, configure Windows Server 2003 to use the Application Server role, and then restart Setup.

  6. Enter the product key and click Next.

  7. In the Components to Install page, select the following components:

    • SQL Server Database Services
    • Reporting Services
    • Workstation components, Books Online, and development tools
  8. In the Instance Name page, you can specify whether Reporting Services and the Database Engine are installed as the default instance (MSSQLSERVER) or as a named instance.

    If the option is available, select Default, and then click Next.

    If the default instance name is not available, enter a name for the instance. Note that when you install a named instance, you cannot install the default configuration for Reporting Services. You will need to manually configure the report server installation after Setup is finished.

  9. In the Service Account page, do the following:

  10. In the Authentication Mode page, specify Windows Authentication. Click Next.

  11. In the Collation Settings page, accept the default value. Click Next.

  12. In the Report Server Installation Options page, select Install the default configuration. If this option is not available, you must select Install but do not configure the server. Click Next.

  13. In the Error and Usage Report Settings page, click Next.

  14. Click Install to begin installation.

Configure the Report Server and install samples

  1. Verify that all services are running. Click Start, click Administrative Tools, click Services, and verify that SQL Server, Reporting Services, and SQL Server Agent are started.

  2. If necessary, configure the report server for operation. This step is necessary if you chose the Install but do not configure the server option during Setup. For instructions, see Configuration: How-to Topics.

  3. Verify that installation succeeded by starting Report Manager. In the URL address, type http://localhost/reports or https://localhost/reports if you enabled SSL on your server. You should see the Report Manager Home page. If you installed the report server as a named instance, the URL will be different. For more information, see Configuring Report Server URLs.

  4. Download and install Reporting Services samples. For more information, see Initial Installation (Reporting Services).

  5. To publish the sample reports to the report server you installed, use Business Intelligence Development Studio. Click Start, point to All Programs, point to Microsoft SQL Server 2005, click Business Intelligence Development Studio.

  6. From the File menu, select Open Project/Solution.

  7. From C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Report Samples\AdventureWorks Sample Reports, select AdventureWorks Sample Reports.sln. Click Open.

  8. From the Build menu, select Deploy Solution.

    The default value for the report server URL is http://localhost/reportserver. If the solution does not deploy, check the report server URL properties. For instructions, see How to: Set Deployment Properties. If the report server URL is correct, open each report and then retry the deployment. Status for a successful deployment is indicated in the Output window. You should see Deploying to http://localhost/reportserver in the Output window, and status for each report and data source uploaded to the server.

  9. Open Report Manager. If it is already open, click the browser Refresh button to display the published items.

  10. Open the AdventureWorks Samples folder. Click a report to view it.


The Sales Reason Comparison sample report uses an Analysis Services database. The report has additional requirements that must be satisfied before you can run the report. For more information, see AdventureWorks Report Samples.

See Also


How to: Troubleshoot a Reporting Services Installation Problem
How to: Verify a Reporting Services Installation
How to: Upload Report Samples (Report Manager)


Considerations for Installing Reporting Services

Other Resources

How Do I Find Tutorials (Reporting Services)
Reporting Services Samples
How to: Install SQL Server (Setup)
Reporting Services Installation How-to Topics
Reporting Services Configuration Tool

Help and Information

Getting SQL Server 2008 Assistance