2

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

Community
  • 1
  • 1
user194076
  • 8,787
  • 23
  • 94
  • 154

1 Answers1

1

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

Brian Knight
  • 4,970
  • 28
  • 34
  • So, select new installation or add shared features? I tried that, but Fetures list look the same. – user194076 Dec 05 '11 at 21:08
  • I'd do the add features - with the list like the one you show above - and let it complete. Then try to add features again. I think the first pass will upgrade the instance to Advanced Services. – Brian Knight Dec 05 '11 at 21:09
  • I cannot run it for the first time, because it says: to continue, select a feature to install. If all features are already selected these features are installed. – user194076 Dec 05 '11 at 21:16
  • Are you not able to upgrade -> see image above. – Brian Knight Dec 05 '11 at 21:32
  • when I'm trying to upgrade, I get: there are no features selected to upgrade. (see updated post) – user194076 Dec 05 '11 at 21:38
  • That's no good - I expected it to be there. Here's a link that shows other people have had the same issue as you -> http://forums.asp.net/t/1317785.aspx/1. Their solution was to uninstall and install Advanced Services from scratch. – Brian Knight Dec 05 '11 at 21:51