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

reporting-services sql-server-express
sqlchild picture sqlchild · Mar 18, 2011 · Viewed 67.3k times · Source

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

marc_s picture marc_s · Mar 18, 2011

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.

Related questions

The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted …

Read More
How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More
SQL variable to hold list of integers

I'm trying to debug someone else's SQL reports and have placed the underlying reports query into a query windows of SQL 2012. One of the parameters the report asks for is a list of integers. This is achieved on the report …

Read More