SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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.

Basit's SQL Server Tips

Basit Farooq is a Lead Database Administrator, Trainer and Technical Author. He has more than a decade of IT experience in development, technical training and database administration on Microsoft SQL Server platforms. Basit has authored numerous SQL Server technical articles, and developed and implemented many successful database infrastructure, data warehouse and business intelligence projects. He holds a master's degree in computer science from London Metropolitan University, and industry standard certifications from Microsoft, Sun, Cisco, Brainbench, Prosoft and APM, including MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.


Leave a comment on the original post [basitaalishan.wordpress.com, opens in a new window]

Loading comments...