How to install SQL Server Reporting Services (SSRS) on an existing SQL Server Express install?

Question

I have SQL Server 2005 Express, but I haven't got SQL Server Reporting Services (SSRS). How do I install it separately? Do I have to download the whole SQL Server setup again, or is there any separate setup for only SSRS?

Answer 1

Check out the SQL Server 2005 Express overview page: there are several versions of SQL Server Express - the basic version doesn't include Reporting Services - you need the SQL Server Express With Advanced Tools version to get Reporting Services.

Here's the download page for SQL Server 2005 Express - if you want Reporting Services, you need to get the "SQL Server 2005 Express Edition with Advanced Services SP3".

Update: this is the SQL Server 2008 Express overview page, from which you can also download the various SQL Server 2008 R2 Express versions. You will need the SQL Server 2008 R2 Express with Advanced Services which includes SSRS 2008.