Re: Cannot upgrade SQL Server 2005 Reporting Services from Standard to Enterprise

You did not show us the command you used for command prompt installation, however did you try something like the following?

start /wait setup.exe /qn INSTANCENAME=<Instancename> UPGRADE=RS_Server SKUUPGRADE=1

That "Evaluation copy: 0 days left" is a remarkable message. Are you sure your SQL Server Instance isn't an Evaluation Edition? Can you check it using "SELECT SERVERPROPERTY('edition')" command? Because an expired evaluation edition instance can not be upgraded, in a situation like this, you need to reinstall it from scratch. However I remember this rule is for Database Instance. I'm not sure if this is also the same for the other services like Reporting Service, but I guess it must be the same... Just a note.


--
Ekrem Önsoy



"Moffitar" <moffitar@xxxxxxxxx> wrote in message news:bc25aa4f-d14d-4f0f-8391-d47fb61d44c2@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi All,
I have a relatively simple question. I have a Windows 2003 R2/SP2 (v.
4035) Server that is running SQL Server 2005 Reporting Services,
Standard Edition. The developers require it to be upgraded to the
Enterprise version because they require specific functionality (the
"unlimited drilldown" feature) that the Standard edition does not
have.

This is to be an in-place "edition" upgrade. I googled the subject
and determined all I would need to do is run the setup wizard and it
would simply unlock the Enterprise functionality. I noted I would
need to run the wizard using the SKUUPGRADE=1 command line option
(bonus tip: this tag is case-sensitive). However, upon running setup,
it apparently didn't detect that I have SSRS installed, because it
only offered to install/upgrade the Client Tools, SSMS, and
Connectivity components.

I cannot continue with the wizard unless I pick one of the above.
there is no option to upgrade SSRS.

Maybe somebody's seen this before?

Here is my configuration:
OS:
Windows 2003 R2/SP2 (v.4035) Server
(Running in a VMWare ESX virtual machine)
1 GB RAM
1.45GB free on C: Drive

Database:
Database is a remote catalog, running on SQL 2005 instance.
Database version is C.0.8.54
Mode is Native.
Connected via Windows account

SSRS info from Log file:
Product is "Microsoft SQL Server Reporting Services Version
9.00.3042.00"
w3wp!resourceutilities!5!8/19/2008-13:46:20:: i INFO: Reporting
Services starting SKU: Standard
w3wp!resourceutilities!5!8/19/2008-13:46:20:: i INFO: Evaluation copy:
0 days left

I note there is an entry stating there are 0 days left for
evaluation. I don't know if this is relevant because the Report
Server appears completely functional in every way. As far as I know
it is the full product.

Thanks!

.

Relevant Pages