1. Run Setup.

2. In the Components to Install page, select SQL Server Database Services, Reporting Services, and Workstation components, Books Online, and development tools.

3. Click Advanced.

4. In Client Components, open Documentation, Samples, and Sample Databases.

5. Click Sample Databases. You should select both AdventureWorks databases if you want to run all of the sample reports. Select Entire feature will be installed on local hard drive.

6. Click Sample Code and Applications. Select Entire feature will be installed on local hard drive. Click Next.

7. In the Instance Name page, select Default instance. Click Next.

8. In the Service Account page, specify a domain user account. In Start services at end of setup, select SQL Server Agent. Click Next.

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

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

11. In the Report Server Installation Options page, select Install the default configuration. Click Next.

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

13. Click Install to begin installation.

1. Click Start, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, click SQL Server Surface Area Configuration.

2. In Surface Area Configuration for Services and Connections, verify that the Report Server Windows service is running. In Surface Area Configuration for Features, verify that Scheduled Events and Report Delivery is enabled. Verify that HTTP and Web Service Requests is enabled. Verify that Windows Integrated Security is enabled.

3. Verify that installation succeeded by launching Report Manager. In the URL address, type https://localhost/reports or http://localhost/reports. 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.

4. 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.

5. 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.

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. If the solution does not deploy, 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.

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.

Tasks

Concepts

Other Resources