SSRS 2008 Installation and Configuration
Reporting Services Installation
Reporting Services 2008 is included as part of the installation for SQL Server 2008. To install Reporting Services, select the checkbox that says “Reporting Services” under the “Instance Features” section.
As part of the installation, a Service Account will be configured for the Report Server.
The Report Server runs under a single Windows Service using either a Built-in account or Domain Windows user account.
The report server service contains:
- Report Server Web Service
- Report Manager
- Background processing application for scheduled report processing and subscription delivery
Although the Report Server Web Service and Report Manager are ASP.NET applications, they do not run under the ASP.NET account. Reporting Services no longer uses IIS, and can be considered self-contained in this respect.
Be sure to choose an account with the appropriate level of access because under certain configurations, different permissions will be needed.
1. Install the native mode default configuration
o Installs the report server and configures it in Native mode to use the default values
2. Install the SharePoint integrated mode default configuration
o Creates the report server database in SharePoint integrated mode and is configured to use the default values
o SharePoint (or a related technology) must be deployed on the report server and the Reporting Services Add-in for SharePoint Technologies must be installed and configured
§ The name of the add-in is Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies
o Additional information for SharePoint integration with Reporting Services can be found at http://msdn.microsoft.com/en-us/library/bb326356.aspx and http://msdn.microsoft.com/en-us/library/bb283190.aspx
o After installing Reporting Services in SharePoint integrated mode, the report server integration settings are configured using the Reporting Services pages in SharePoint Central Administration’s Application Management tab.
§ If the Reporting Services pages do not exist, then the Report Server Integration Feature in the Site Collections Features needs to be activated.
3. Install, but do not configure the report server
o Installs the report server but does not configure it
o Reporting services must be configured using the Reporting Services Configuration tool before it is usable
If choosing one of the default configurations, setup will configure the following:
· Service account for the Report Server instance
· Report Server Web Service URL
· Report Manager URL
· Report Server Database
· Service account access to the report server database
· DSN connection to the report server database
If choosing one of the default configurations, setup will not configure the following:
· Unattended Execution account
· Report Server E-mail
· Backup the encryption keys
· Scale-out deployment
The following are the default configuration values:
o If an SSL certificate is installed, HTTPS will be used
· Host name
o 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://localhost/reportserver, or .
o 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.