How to Install SQL Server 2008 Reporting Services
by
Doug
Updated April 10, 2010
From the SQL Server 2008 Installation menu, click "New SQL Server stand-alone installation or add features to an existing installation.
Add features to an existing instance of SQL Server 2008.
Check the box next to "Reporting Services", to add Reporting Services to an existing SQL Server 2008 database.
Choose 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).
Setup will install, but will not configure, the report server software.
To double check SQL Server Reporting Services is installed as a service on your computer, by locating it within the Computer Managment - Services section.
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
- Insert the Microsoft SQL Server 2008 product DVD into the DVD Drive, and run Setup.exe to open the "SQL Server Installation Center"
- 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".
- 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".
- In the Features Selection window, locate "Reporting Services" (It is below "Instance Features"), and check the box next to "Reporting Services", then click "Next".
- Click "Next" on the Disk Space Requirements window.
- 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.
- In the Reporting Services Configuration window, choose "Install, but do not configure the report server" and click "Next".
- 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".
- 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