• Article

Report Server Installation Options

Use the Report Server Installation Options page of the Microsoft SQL Server Installation Wizard to specify options that determine how a report server instance is installed. The availability of an installation option depends on whether you are also installing a local instance of SQL Server Database Engine at the same time you are installing the report server, and whether other default values are available to use.

If Setup cannot perform a default report server configuration because one or more requirements are not met, the Installation Wizard allows only the minimal installation option; copying the files you need, but requiring you to use the Reporting Services Configuration tool to configure the report server after setup is finished.

In some cases, if a Secure Sockets Layer (SSL) certificate is installed on the computer and is bound to a strong wildcard, Setup will create the Reporting Services URLs using the HTTPS prefix. For more information about how certificates are mapped to Reporting Services URLs, see Configuring a Report Server for Secure Sockets Layer (SSL) Connections in SQL Server Books Online.

Note

An existing report server database file can cause setup to fail if you choose one of the default installation options. When you choose a default installation option, setup attempts to create a report server database using the default name. If a database with that name already exists, setup will fail and you will have to rollback the installation. To avoid this problem, you can rename the existing database before you run setup or choose the Install but do not configure server option so that you can specify custom database settings after setup is finished.

Options

  • Install the native mode default configuration
    Installs a report server instance using the default values for the report server databases, service account, and URL reservations. When you choose this option, the report server instance is ready to use when Setup is finished. Setup creates the report server database using a local Database Engine instance, and configures a report server to use default values.

    This option is available only if the default values used in a report server installation are valid for your system. This option is recommended for developers who want to install all components locally, and for users who are evaluating the software.

    To view information about the default Settings that Setup uses, or to find out why the default configuration cannot be installed, click Details. For more information about the default configuration for a native mode report server, see Default Configuration for a Native Mode Installation (Reporting Services).

  • Install the SharePoint integrated mode default configuration
    Installs a report server instance using the default values for the report server databases, service account, and URL reservations. The report server database is created in a format that supports content storage and addressing from a SharePoint site. For more information about this installation option, see Default Configuration for SharePoint Integrated Mode (Reporting Services).

    After you install a report server instance in SharePoint integrated mode, there are additional configuration steps to complete the integration with a SharePoint environment. The additional steps include installing or verifying the installation of the Reporting Services Add-in for SharePoint Technologies on the SharePoint Web Front-Ends.

  • Install but do not configure the server
    Installs the report server program files, creates the Report Server service account, and registers the report server Windows Management Instrumentation (WMI) provider. This installation option is referred to as a "files-only" installation. Select this option if you do not want to use the default configuration. If the default configuration cannot be installed, or if you are installing a SQL Server failover cluster that includes Reporting Services, this is the only option available. For more information about a files-only installation, see Files-Only Installation (Reporting Services).

    After Setup completes, you must create the report server database and configure the report server before it can be used. To configure a report server and create the database, use the Reporting Services Configuration tool. For more information, see How to: Create a Report Server Database (Reporting Services Configuration) and Configuring a Report Server Database Connection.

Installing the Reporting Services Add-in for SharePoint Technologies

To install the Reporting Services Add-in for SharePoint Technologies, click the rsSharePoint.msi file in the Setup folder on SQL Server installation media after SQL Server Setup is complete. The add-in is also installed as part of the SharePoint 2010 products pre-requisite installer. You can also download the add-in. For more information, see SQL Server® 2008 R2 Reporting Services Add-in for Microsoft SharePoint® Technologies 2010.