Installing the Sample Reports and Setting up the Demo Application

The installation procedures for the Reporting Services sample reports differ slightly between SQL Server 2000 and SQL Server 2005. Follow the appropriate procedure for your particular system.

SQL Server 2000

1. When you run the setup program for SQL Server 2000 Reporting Services, select both the Reporting Services Samples and AdventureWorks Database options.
2. Open the Readme.htm file located in the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\ Scripts folder.
3. Follow the instructions for running the PublishSampleReports.rss script. The script takes an input parameter called parentFolder, which lets you explicitly specify the folder where you want to publish the reports. If a folder with that name doesn't exist, the script will create it.
4. Modify the App.Config file in the demo application.You might need to change the server part in the RsUrl settings from localhost to the name of the server where you installed the sample reports.You must change the folder part of the ReportPath setting from SampleReports to the name of the folder you created when you published the reports in the previous step.

SQL Server 2005

1. When you run the setup program for SQL Server 2005, select the Sample Databases option and the Sample Code and Applications option.
2. Run the Microsoft SQL Server 2005 Samples install file.To access the file, click Start, then select All Programs, Microsoft SQL Server 2005, Documentation and Tutorials, Samples.
3. Open the Readme_ScriptSamples.htm file located in the C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Script Samples folder.
4. Follow the instructions for running the PublishSampleReports.rss script file. The script installs the sample reports in the AdventureWorks Sample Reports folder.
5. Modify the App.Config file in the demo application.You might need to change the server part in the RsUrl settings from localhost to the name of the server where you installed the sample reports. Change the folder part of the ReportPath setting from SampleReports to AdventureWorks Sample Reports.