Default Configuration for SharePoint Integrated Mode (Reporting Services)
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.
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.
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.
URL reservations are composed of a prefix, host name, port, and virtual directory:
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.
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.
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.
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:
Provides access to the report server.
Provides access to Report Manager.
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.
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.
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"
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.