Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Install Reporting Services


SQL Server Reporting Services 2008 (SSRS) is a feature included in the SQL Server 2008 product.  To install SSRS you run the SQL Server 2008 SETUP.EXE program which guides you through the various installation and configuration options for the product.  In this section we will discuss the installation and configuration options that pertain to installing SSRS. 

As you proceed through the SQL Server 2008 installation process, you will reach the Feature Selection dialog.  Click the checkbox for Reporting Services to perform the installation of SSRS as shown below under Instance Features:

Note that you should also probably check everything under Shared Features, especially Business Intelligence Development Studio as we use this tool to design, develop, test, and deploy reports.

Later in the SQL Server 2008 installation process you will reach the Reporting Services Configuration dialog as shown below:

Select the first option - Install the native mode default configuration.  This will install SSRS and configure it for you automatically.  SharePoint integrated mode disables the Report Manager and allows you to store reports in SharePoint document libraries; to run a report you simply click on it.  The last option is useful where you want to configure the report server manually using the Reporting Services Configuration Manager.

You can begin using SSRS as soon as the SQL Server 2008 installation is complete, assuming you chose Install the native mode default configuration.

Additional Information

More SQL Server Solutions

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 

SQL tips:

*Enter Code refresh code     

Learn more about SQL Server tools