Hello all,
I have a SQL Server 2005 64-bit Standard Edition install of the database engine and Reporting Services on a server. The BI team would like us to upgrade the server from Standard Edition to Enterprise Edition of SQL Server and Reporting Services to take advantage of data driven subscriptions.
Does anyone know if this is a straightforward upgrade (another words .. install EE on top of SE), or is it better to backup the databases, remove SQL Server and RS, do a clean install, and restore the databases back to the server
Thanks,
Eric
Upgrading Reporting Services 2005
Joshua Baker
Eric,
You should be able to just run EE setup.exe and it will upgrade the edition. It is recommended to backup the RS databases (in Management Studio) and the encryption key (in RS Configuration Tool), but this is just a precaution in case something goes wrong and you need to recover. If you have custom extensions or assemblies referenced in your RSReportServer.config and web.config file, you should backup the .config files also.
Mike