Default Configuration for SharePoint Integrated Mode (Reporting Services)

SQL Server Setup

Default configuration for SharePoint integrated mode refers to a Reporting Services installation where Setup both installs and configures a report server instance, and creates the report server database in a format that supports content storage and addressing from a SharePoint site.

Setup installs the following Reporting Services features when you select the default configuration for SharePoint integrated mode option: Report Server service, Report Builder, Report Designer Preview, the Reporting Services Configuration tool, and the Reporting Services command line utilities (rsconfig.exe, rskeymgmt.exe and rs.exe). This option does not apply to shared features such as SQL Server Management Studio or Business Intelligence Development Studio, which must be specified as separate items if you want to install them.

When you select a default configuration option in Setup, Setup will configure the report server in either native mode or SharePoint integrated mode. For a SharePoint integrated mode report server, Setup configures the following:

  • Service account for the Report Server service.
  • Report Server Web service URL.
  • Report Manager URL.
  • Report Server database.
  • Service account access to the report server databases.
  • DSN connection to the report server databases.

Setup does not configure the unattended execution account, report server e-mail, back up the encryption keys, or a scale-out deployment. You can use the Reporting Services Configuration tool to configure these properties. For more information, see Reporting Services Configuration Tool.

After Setup is finished, the report server might not be fully operational, because it is not yet fully integrated with a SharePoint farm. You must still install a Reporting Services Add-in, configure integration settings, and possibly install additional prerequisite software if you are integrating the report server with a SharePoint farm that spans multiple servers. For more information, see Configuring Reporting Services for SharePoint 3.0 Integration.

When to Install the Default Configuration for SharePoint Integrated Mode

This installation option configures the report server's core settings that enable the report server to be integrated with Windows SharePoint Services or Microsoft Office SharePoint Server . Specify this mode when:

  • You want to save steps by eliminating any required configuration tasks you would otherwise have to perform in the Reporting Services Configuration tool. The default values for the Reporting Services URLs, database name, and virtual directories must be available to use. These values must be unique. If they are already used by another installation on the computer, Setup cannot use them to configure a default installation.
  • You plan to immediately install the Reporting Services Add-in and configure report server integration settings on the SharePoint site. If the report server provides report processing capability to a SharePoint farm, you must also install a SharePoint Web front end on the report server computer so that you can join it to the farm. For more information, see Configuring Reporting Services for SharePoint 3.0 Integration.

Requirements

This installation option has the following requirements:

  • Reporting Services and SQL Server Database Engine must be installed together in the same instance. The Database Engine instance hosts the report server database that Setup creates and configures.
  • The user account used to run Setup must be a member of the Administrators group on the local computer and must have permission to access and create databases that use the Database Engine instance that hosts the report server databases.
  • Setup must be able to use the default values to reserve the URLs that provide access to the report server and Report Manager. These values are port 80, a strong wildcard, and the virtual directory names in the format ReportServer_<instance_name> and Reports_<instance_name>.
  • Setup must be able to use the default values to create the report server databases. For a default instance, these values are ReportServer and ReportServerTempDB. If you have existing databases from a previous installation, Setup will be blocked because it cannot configure the report server. You must rename, move, or delete the databases to unblock Setup.

Setup does not check for a SharePoint product or technology installation on the local machine, nor does it install the Reporting Services Add-in and configure integration settings in SharePoint Central Administration. You must install and configure these applications separately. For more information, see Configuring Reporting Services for SharePoint 3.0 Integration.

If your computer does not meet these requirements for a default installation, you must install Reporting Services in files-only mode and configure it manually after Setup is finished. You can use the Reporting Services Configuration tool to configure Reporting Services.

Do not try to reconfigure your computer only to allow a default installation to continue. Doing so could require several hours of work, effectively eliminating the time-saving benefit the installation option provides. The best solution is to install Reporting Services in files-only mode and then configure the report server to use specific values.

Default URL Reservations

URL reservations are composed of a prefix, host name, port, and virtual directory:

Part Description

Prefix

The default prefix is HTTP. If you previously installed a Secure Sockets Layer (SSL) certificate, Setup will try to create URL reservations that use the HTTPS prefix.

Host name

The default host name is a strong wildcard (+). It specifies that the report server will accept any HTTP request on the designated port for any host name that resolves to the computer, including http://<computername>/reportserver, http://localhost/reportserver, or http://<IPAddress>/reportserver.

Port

The default port is 80. If you install Reporting Services on 32-bit Windows XP SP2, the default port is 8080. Note that if you use any port other than port 80, you will have to explicitly add it to the URL when you open a Reporting Services Web application in a browser window.

Virtual directory

By default, virtual directories are created in the format of ReportServer_<instance_name> for the Report Server Web service and Reports_<instance_name> for Report Manager. For the Report Server Web service, the default virtual directory is reportserver. For Report Manager, the default virtual directory is reports.

An example of the complete URL string might be as follows:

Example URL Description

http://+:80/reportserver

Provides access to the report server.

http://+:80/reports

Provides access to Report Manager.

Note:
In SharePoint integrated mode, this URL will produce the rsOperationNotSupportedSharePointMode error message because Report Manager is not supported in this mode. In this mode, it is expected that all content management and report access is handled through SharePoint instead of Report Manager.

How to Install a Report Server in the Default Configuration for SharePoint Integrated Mode

You can specify a SharePoint mode default configuration through the command line or in the Installation wizard. The following topics provide step-by-step instructions:

Example Command Line Script

This example includes the Database Engine Service because it is required for a default configuration.

Copy Code
setup /q /ACTION=install /FEATURES=SQL,RS,TOOLS /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /RSSVCSTARTUPTYPE="Manual" /RSINSTALLMODE="DefaultSharePointMode"

Installation Wizard

When you select Reporting Services in the Feature Selection page, Setup provides a Reporting Services Configuration page that allows you to specify the installation mode. To specify a SharePoint integrated mode installation, select Install the SharePoint integrated mode default configuration on the Reporting Services Configuration page.

See Also