Install Reporting Services




By:

Overview
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. 

Explanation
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


Last Update: 1/5/2010




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
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.






download





get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools