Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to upgrade report from SQL Server 2000 to SQL Server 2005?

April 26, 2017report SQL Server upgrade

0

Posted

How to upgrade report from SQL Server 2000 to SQL Server 2005?

1 Answer

0

Posted

You can use the following steps: 1. Back up ReportServer and ReportServerTemDB. 2. Back up encryption keys from Reporting services 2000 by using RsKeyMgmt. 3. Restore the databases backed up from step 1. 4. Connect to newly restored databases from step 3 from Reporting Services 2005 Configuration manager and database setup. 5. By using the provided credentials, Reporting Services will connect to new databases and perform the upgrade operations. 6. Confirm Reporting services upgrading the database and granting adequate rights to the credential account. 7. Restore backed up keys from step 2. Confirm that everything is displayed as green now.