Tallan Blog

Tallan’s Experts Share Their Knowledge on Technology, Trends and Solutions to Business Challenges

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:

·         Prefix

o   HTTP

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://<computername>/reportserver, http://localhost/reportserver , or http://<IPAddress>/reportserver.

·         Port

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.

Share this post:

1 Comment. Leave new


Will it be possible to run Report Server Web Service URL in 80 port of XP operating system?.

With Regards,

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>