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:

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.

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:

• How to: Install SQL Server 2008 (Setup).
  
• How to: Install SQL Server 2008 from the Command Prompt.
  

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.