Minimum config to upgrade 2000 to 2005?

I am trying to upgrade from SQL Server 2000 Developer Edition (SP4) to SQL Server 2005 Developer Edition. I want to be able to use Reporting Services in the 2005 version. But the 2005 Upgrade Advisor says:

Reporting Services is either not installed or is installed incorrectly.
- Virtual directory settings do not match the default configuration
- Custom virtual directory settings block edition upgrades
- Custom extensions are deployed on the report server
- ASP.NET account information is encrypted

What do I need to install from the 2000 product in order to be able to upgrade to the 2005 version?

You should only get this warning if one of these conditions is true. Have you verfied each one?

Here is how to check:

1) Have you modified the IIS settings for either the Report or ReportServer vdir in any way?

2) Did you modify the config file to add any custom extensions?

3) Is your machine.config file set to encrypt the asp.net account password?

If you check all of this and still can't find the issue, you can always uninstall RS (this will still leave the RS catalog around), Install RS 2005. Use the 2005 configuration tool to point RS to the old DB and upgrade it to the new schema. The use that DB as the report server DB. You will then continue to maintain all of your old reports but will gain all the new features of RS 2005.

|||

Daniel, thanks for your help. I'm on the (very) low end of experience with all this.

>1) Have you modified the IIS settings for either the Report or ReportServer vdir in any way?

I uninstalled all SQL Server components (both 2005 and 2000) and then reinstalled 2000, 2000 SP4 and 2005. So, it seems like the answer here is no.

>2) Did you modify the config file to add any custom extensions?

I don't think so. Where should I look?

>3) Is your machine.config file set to encrypt the asp.net account password?

Where should I look for this file? (I guess the fact that I'm even asking this implies I have not messed with it ... but don't assume too much.)

>If you check all of this and still can't find the issue, you can always uninstall RS

I don't think it was ever installed in the first place.

|||It sounds like you are just trying to install RS2005. You do not need to install RS 2000 to get RS2005. Just install 2005.|||

Daniel Reib wrote:

If you check all of this and still can't find the issue, you can always uninstall RS (this will still leave the RS catalog around), Install RS 2005. Use the 2005 configuration tool to point RS to the old DB and upgrade it to the new schema. The use that DB as the report server DB. You will then continue to maintain all of your old reports but will gain all the new features of RS 2005.

I have a case where I need to upgrade both the DB and the RS from 2000 to 2005. The procedure above seem to work great except from one thing - I don't know how to transfer the encryption keys. I have made the keyfile with rskeymgmt but in the 2005 config screen i get an error when trying to restore the encryption keys:

ReportServicesConfigUI.WMIProvider.WMIProviderException: Could not find stored procedure 'SetKeysForInstallation'.
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.RestoreEncryptionKey(Byte[] encryptedBytes, String password)

Anyone knows what this means?

Regards,

|||This procedure was added for RS2005. It appears like you are still pointing to your RS 2000 db or it has not upgraded correctly.|||

Still pointing to the RS 2000 db, isn't that what you say we should do? And RS 2005 will upgrade the schema? That step reported no errors whatsoever..

|||When you point to the 2000 DB the config tool should tell you that it is upgrading. If it did not you can always script the upgrade (using the config tool) and then just run the scripts.|||

That step didn't report any errors, it worked out great. The only config step I still have problems with is Encryption Keys (which reports the error I posted earlier) and Initialization (reports an x in the icon, and I'm not able to click it. It's grayed out).

I tried the following now:

C:\Documents and Settings\Administrator>rskeymgmt -a -fdesktop\keys.snk -ppassword

Could not find stored procedure 'SetKeysForInstallation'.

C:\Documents and Settings\Administrator>

Which is basicly the same error as I posted earlier... any idea of what step I've missed that can cause this? I see that it's true.. there is no sp names SetKeysForInstallation in the db..