How to Install SQL Server 2008 Reporting Services

by Updated April 10, 2010

I recently upgraded from Microsoft SQL Server 2005 to Microsoft SQL Server 2008 on my Windows Vista computer.  After successfully installing SQL Server 2008, I could not find the Reporting Services instance installed.  I have a feeling this was due to the fact that I had never installed Reporting Services on the SQL Server 2005, so when I upgraded to 2008 it carried over the previous settings from 2005 and I never got a chance to select Reporting Services during the initial install.  Because of this, I had to add/install the Reporting Services feature seperately to my existing SQL Server 2008 database afterwards.

Follow these steps to install Microsoft SQL Server 2008 Reporting Services (SSRS) to an existing SQL Server 2008 installation.

To install SQL Server 2008 Reporting Services

  1. Insert the Microsoft SQL Server 2008 product DVD into the DVD Drive, and run Setup.exe to open the "SQL Server Installation Center"
  2. In the SQL Server Installation Center window, click "Installation" from the left-hand menu, then click "New SQL Server stand-alone installation or add features to an existing installation".
  3. Now step through the initial setup steps.  Once you get to the "Installation Type" screen choose "Add features to an existing instance of SQL Server 2008", then select your instance and click "Next".
  4. In the Features Selection window, locate "Reporting Services" (It is below "Instance Features"), and check the box next to "Reporting Services", then click "Next".
  5. Click "Next" on the Disk Space Requirements window.
  6. In the Server Configuration window, select an 'Account Name' for Sql Server Reporting Services.  In my case, I choose the local SYSTEM account (I did not have to enter a password). Once you've choosen your 'Account Name' click the "Next" button.
  7. In the Reporting Services Configuration window, choose "Install, but do not configure the report server" and click "Next".
  8. Then click "Next" buttons, until you get to the "Ready to Install" window, and then click the "Install" button. Once the Installation setup process is complete and successfully installed, click "Next", then from the Complete window, click "Close".
  9. That's it!

Before configuring Reporting Services, you may want to make sure that Reporting Services service is installed on your computer, to do so follow these steps: 

Open "Control Panel" -> System and Maintenance -> Administrative Tools -> Computer Management -> expand the "Services and Applications" menu -> click on "Services" -> now locate SQL Server Reporting Services (MSSSQLSERVER) in the Services window pain.

OK, so once you know SQL Server Reporting Services is on your system, you will now have to configure Reporting Services for your computer. To get started with configuration, check out: http://technet.microsoft.com/en-us/library/ms159644.aspx 

To configure a URL for the Report Server Web service, check out: http://technet.microsoft.com/en-us/library/bb630447.aspx

To create a Report Server Database for Reporting Services, check out: http://technet.microsoft.com/en-us/library/ms157300.aspx

For more Reporting Services Configuration How-to Topics, check out: http://technet.microsoft.com/en-us/library/ms157412.aspx

Also check out the MSDN Reporting Services forum here: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads

 

 


0
4

4 Comments

anonymous by Nicolas on 1/3/2012
Thank you so much. Right to the point. I wish MSDN would learn from you when they make documentation. Cheers.
anonymous by Seb on 3/9/2012
This article is also a nice walk-through on how to install SSRS 2008:
http://www.soheib.com/knowledge/how-to-install-sql-server-reporting-services-2008-on-a-virtual-machine/
anonymous by adam on 8/8/2012
This doesn't work for me! When I do add features to an existing installation, it only shows 3 items, however if I do a completely new installation it has Reporting Services shown in the list of options. I initially installed from an installer that wasn't advanced services (express).
anonymous by Dishon Michael on 11/8/2012
Thank you so much for helping me out.

Add your comment

by Anonymous - Already have an account? Login now!
Your Name:  

Comment:  
Enter the text you see in the image below
What do you see?
Can't read the image? View a new one.
Your comment will appear after being approved.

Related Posts


Here's one way to setup your connection string for a SQL Server 2008 Express database for a live website using ASP.NET on Windows Server 2008. Open "Sql Server Configuration Manager" -> the click on "SQL Server Network Configuration" -> then click...  more »

I recently dealt with an issue of external images not showing in Reporting Services (SSRS) report viewer control within an IIS7 website. When the IIS7 website had it's Application Pool's Managed Pipeline Mode set to "Classic", the external images showed...  more »

SQL Server Reporting Services can be a pain in the arse to set up correctly for the first time. Even after you've got things running correctly, you can sometimes run into issues, which is exactly what happened to me recently. I had setup my local...  more »

When using SQL Server 2008, you may receive a Save (Not Permitted Dialog) box pop-up when trying to save changes to an existing table. The dailog box reads: "Saving changes is not permitted. The changes you have made require the following tables to be...  more »

If you are getting the following error while trying to access or deploy a SQL Services Reporting Services (ssrs) report server on your localhost: The permissions granted to user 'domain\username' are insufficient for performing this operation....  more »