Installing features in SQL Server 2008

2
votes

I have existing installation of SQL server 2008 r2 express. I need to add SSRS features to my installation. So I found this topic, whic says that I have to download SQLserver express with advanced services. Reporting Services availability SQL Server Express 2008 R2 I did download that packet, but here's a screenshot of what I got:

enter image description here

Which indicates that all features are installed and no way to add SSRS. What am I missing?

UPDATE I selected existing installation on step two of the wizard. See screenshot below: enter image description here

When I try to upgrade, to new version, there's what I've got:

enter image description here

1
sql-serversql-server-2008-r2
Did you choose the same instance name as your original install when running the Advanced setup? - Joe Stefanelli
@JoeStefanelli, I believe so, I added the screen from the second step to the post. - user194076

1 Answers

1
votes

It may be that you have to upgrade to SQL Server 2008 R2 with Advanced Services first, and then add the feature afterward. SQL Server 2008 R2 Express and SQL Server 2008 R2 with Advanced Services are technically different "versions", but an upgrade path is supported. I would try to upgrade - run the package without adding new features - and then see if the Reporting Services functionality is available.

enter image description here