September 2, 2008 at 4:30 pm
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!
September 8, 2008 at 1:54 pm
Anyone? Anyone? Bueller?
I'm getting ready to uninstall/reinstall, and migrate databases and configuration as noted here:
http://msdn.microsoft.com/en-us/library/ms143724(SQL.90).aspx
...unless someone has a better idea.
Thanks!
September 9, 2008 at 12:53 pm
My 2 cents... I would go ahead with the install (on a test server!!!) and then un-install re-install SSRS. You should then be able to connect to your previous SSRS database(s) without any problems. This is only a suggestion, I have not tried this upgrade method, nor have I read up on it. My assumption is that during your Sql Server upgrade, SSRS will be identified and upgrade(d) as well, but again I would try it in test first.
September 9, 2008 at 6:32 pm
Update:
I think I figured out the reason I am not able to upgrade SSRS. The current instance is patched to SP2, and the version on the CD is RTM. I noted I am also unable to even install a second SSRS instance on the machine. Looks like the only path is to rip-and-replace, and reattach databases afterward. I still haven't completed it yet, because the customer is tracking down the password for the original installation.
September 9, 2008 at 6:38 pm
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.
As far as SQL server installer concerns it is an expired evaluation copy. Per MS, expired evaluation copies could not be upgraded to anything. That is the only reason you do not see it in the installation list. You can uninstall reporting services; upgrade the DB to Enterprise edition and then install Reporting services.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply