.png)
Installation Overview (SSRS)
[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]
SQL Server Reporting Services (SSRS) is installed through the SQL Server Code-Named “Denali” Setup program. You can install Reporting Services alongside other SQL Server components or you can install Reporting Services as a stand-alone component. Reporting Services includes both client and server applications, and it requires access to an instance of the SQL Server Database Engine that is used to host the report server database that provides internal storage for a report server installation.
When you install Reporting Services, you can one of three installation options:
-
Install the native mode default configuration.
-
Install the SharePoint integrated mode default configuration.
-
Install files with no configuration. This is referred to as ‘files-only installation’. You can use the Reporting Services Configuration Manager to configure the server after a files-only installation.
SQL Server 2008 introduces fundamental changes to the prerequisites and server hosting environment of Reporting Services. If you are familiar with previous versions of Reporting Services and installing SQL Server 2008 R2 Reporting Services for the first time, review the following points:
-
The prerequisite check for Microsoft Internet Information Services (IIS) and ASP.NET is removed. Reporting Services uses a native hosting environment and the SQL Server common language runtime in this release. For more information, see What's New (Reporting Services).
-
Setup supports installation options for default configuration (native mode), default configuration (SharePoint integrated mode), and a files-only installation option so that you can specify all report server configuration after Setup is finished. The default configuration options for Reporting Services require that the SQL Server Database Engine be installed with Reporting Services.
The default configuration for SharePoint integrated mode is new in SQL Server 2008. It provides a way to install the report server database in a format that supports integrated operations. Additional configuration steps will still be necessary. You must still install the Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies and specify report server integration settings and permissions on the SharePoint site. In addition, if the report server is on a different computer, you must install and configure a Web front end to join the report server to a SharePoint farm. For more information about these installation options, see Install a Report Server in Native Mode (SSRS) and Configuring Reporting Services for SharePoint 2010 Integration.
-
If you install Reporting Services on a computer that has IIS installed, you might encounter interoperability issues that can be difficult to detect if you are not aware of them. See Installing Reporting Services and Internet Information Services Side-by-Side for details.
-
If you install SharePoint Server 2010 and Reporting Services, there might be a conflict with the default Report Center URL in SharePoint. This is because Report Center and Reporting Services Report Manager use the same default URL of http://computer_name/reports. You should use the Reporting Services Configuration tool to configure the report server and Report Manager to use a different port or virtual directory than SharePoint.
If you have a deployment of an earlier version of Reporting Services and are installing SQL Server 2008 R2 to try out new features, be sure to backup your report definition files and report server databases. After you install SQL Server 2008 R2, the report server database version will be upgraded automatically when the Report Server service starts. The report server content will be upgraded automatically when you first run the report against a SQL Server 2008 R2 report server instance.
To get started, choose the item that best matches your objective, and then click a link for more information.
-
Read about hardware and software requirements, or to learn more about components in SQL Server. For more information, see Hardware and Software Requirements for Installing SQL Server "Denali" and Editions and Components of SQL Server "Denali".
-
Read about components in Reporting Services and how to specify installation options to select the components you want to use. For more information, see Component Architecture and Installing Reporting Services.
-
Evaluate different deployment topologies and identify the requirements for a specific scenario. For more information, see the topics in Planning and Architecture (Reporting Services).
-
Learn about different approaches for installing Reporting Services and the difference between a files-only installation and the default configuration. For more information, see Installing Reporting Services.
-
Install Reporting Services. For more information, see How to: Install SQL Server "Denali" (Setup) or How to: Install SQL Server "Denali" from the Command Prompt.
-
To install Reporting Services and the report server database on different computers, select the Install but do not configure the report server option in setup or the Files-Only installation mode in a command line installation, and then create the report server database on the remote SQL Server instance after setup is finished. For more information, see How to: Install SQL Server "Denali" (Setup) and Creating a Report Server Database.
Note
|
|---|
|
For local installations, you must run Setup as an administrator. If you install SQL Server from a remote computer, you must use a domain account that has read and execute permissions on the remote share. |
After you install Reporting Services, you can do the following:
-
Verify installation succeeded by starting Report Manager.
-
Download and install Reporting Services samples.
-
Use the tutorials to try out specific features and learn basic skills.
The following sections provide instructions for performing these steps.
Starting Report Manager
When you select the Install the default configuration option in Setup, you can immediately verify that the report server is configured and operational by starting Report Manager.
To start Report Manager, open a browser window. In the URL address, type http://localhost/reports. You should see the Report Manager Home page.
|
Note
|
|---|
|
If you installed the report server as a named instance, the default URL that Setup creates will include the instance name. For more information, see Configuring Report Server URLs. |
If you installed Reporting Services in SharePoint integrated mode, the rsOperationNotSupportedSharePointMode error message should appear when you try to browse to the Report Manager URL. Additionally, after a successful installation and configuration of the report server in SharePoint integrated mode, you should be able to browse to the report server URL and see the SharePoint site collection URL in the SharePoint farm. For more information, see Configuring Reporting Services for SharePoint 2010 Integration.
If you have trouble starting Report Manager, see How to: Troubleshoot a Reporting Services Installation Problem.
Reporting Services Tutorials
Reporting Services includes tutorials to help developers, administrators, and report authors learn basic skills. If you are new to Reporting Services, you can use the tutorials to try out specific features in different areas of the product to further confirm that the installation is successful. For more information, see How Do I Find Tutorials (Reporting Services).
