• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 782
  • Last Modified:

SQL Server Reporting Services Version = 9.00.3042.00 - inidcates Express but installed WorkGroup

Hi all.. I installed MS SQL Server 2005 workgroup edition which should have also installed the same reporting services version, however... this doesn't appear to be the case.  I need to create report subscriptions and am unable to do so since this version of RS doesn't include  this functionality.  When I try to 'upgrade the RS component' of SQL Server, nothing happens because the installation seems to indicate the corresponding version of RS is already installed.  Another thing to note is:  During RS configuration the ReportServer db created is named : ReportServer and not ReportServer_Express.

Any ideas?
Thanks!
0
tgreendyk
Asked:
tgreendyk
  • 4
  • 3
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Do you have Express with Advanced Services installed in your machine..
That might have probably installed Reporting Services Express version in your machine..
0
 
tgreendykAuthor Commented:
At one point Enterprise Studio express may have been installed but that was uninstalled and SQL server 2005 Workgroup was installed along with the Reporting Services components.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> that was uninstalled and SQL server 2005 Workgroup was installed

Your Express components was not completely removed out and hence Reporting Services Express was still in your machine..
Kindly uninstall it completely and try again..
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
tgreendykAuthor Commented:
Thanks!  I've done this twice already and am not sure if repeating the same steps will produce a different result.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Kindly check the presence of SQL Server Express edition in the following places:

* SQL Server Configuration Manager ---> Under Network Configuration
* Add/ Remove programs
0
 
tgreendykAuthor Commented:
I subsequently learned that the version number for Express with Advanced optionas and SQL Server 2005 SP2 have the same version numbers.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Version no. is the same across all Editions of SQL Server..
You can check the edition currently running using this:

SELECT SERVERPROPERTY('edition')

Missed noticing your Question title earlier..
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now