Export (0) Print
Expand All
8 out of 20 rated this helpful - Rate this topic

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.

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

  2. Run Setup.exe from the SQL Server 2005 installation media.

  3. 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. Click Advanced.

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

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

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

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

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

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

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

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

  17. Click Install to begin installation.

  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 Reporting Services 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 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, 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.

  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.

ms144290.note(en-US,SQL.90).gifNote:
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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.