How to: Install Reporting Services on a Single Computer

SQL Server 2005

Updated:
15 September 2007

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 following components:

The Database Engine, used for hosting the report server database and necessary for installing the report server in default configuration mode.

The Reporting Services samples, useful for trying out Reporting Services features. Note that SQL Server 2005 setup only copies the samples Setup program to the disk drive. After setup is complete, you must run the samples Setup program to install the files and then upload the samples to the report server.

These instructions assume that you are installing Reporting Services for the first time. If you are upgrading or reinstalling, you might not be able to use the default configuration installation option. In this case, you should 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 Upgrading Reporting Services.

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.

Enter the product key and click Next.

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

SQL Server Database Services

Reporting Services

Workstation components, Books Online, and development tools

Click Advanced.

In Documentation, Samples, and Sample Databases, click Sample Databases. You should select both AdventureWorks databases if you want to run all of the sample reports. To select the databases, click Entire feature will be installed on local hard drive.

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.

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 Virtual Directories.

To install samples, click Start, point to All Programs, point to Microsoft SQL Server 2005, point to Documentation and Tutorials, point to Samples, click Microsoft SQL Server 2005 Samples. Use the Installation wizard to install the samples.

To publish the reports, use Business Intelligence Development Studio. Click Start, point to All Programs, point to Microsoft SQL Server 2005, click Business Intelligence Development Studio.

If the solution does not deploy, check the report server URL properties. For instructions, see How to: Set Deployment Properties (Report Designer). 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.

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

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

Note:

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.