A Guide for Installing SQL Server 2008 R2 Reporting Services

Check out my article on SQLServerCentral.com in which I discussed SQL Server 2008 R2 installation setup which you can use to install and configure Microsoft SQL Server 2008 Reporting Services. The most of the installation process is managed by the Setup.exe installation wizard, so expect to be prompted for a number of configuration options that determine how, where, and whether each segment of the Reporting Services package will be installed. As we know that there are a variety of ways to install Reporting Services, so I’ve tried not only to address the common case, but also provide hints and techniques to be used for some of the more sophisticated installation scenarios. In this article I will be covering following sections:

  • Installation Prerequisites and Preparation for Installation: This section discusses things you need to consider for the installation of Reporting Services.
  • Installing Reporting Services on a Server: This section walks through the Setup wizard and discusses how to respond to each dialog.
  • After Installation Configuration: This section discusses the use the Report Server Configuration Manager to configure and start newly installed Reporting Services instance.
  • Verifying and Securing Reporting Services Installation: In this section we will first verify Reporting Services installation by connecting to report manager and then we will show how to secure your Reporting Services Manager.

The procedures described are for a non-clustered server, and can be applied either to a default instance or a named instance. This document is concerned with building a dedicated Reporting Services instance, with the databases on a remote server.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s