Moving SSRS from one SQL machine to another

Check this link below.  I’m not sure if you are downgrading as the page suggests, but if you are using SQL Server 2005 Standard Edition, it doesn’t support scale out deployment.  Not that you are using Scale Out deployment, but the old machine/ instance id is probably still registered in the SSRS database.

http://www.sqlwebpedia.com/content/how-move-reporting-services-new-server

+Ryan Creps

+Tessitura Network

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Larry Brindise
Sent: Monday, December 12, 2011 5:23 PM
To: Ryan Creps
Subject: [Tessitura Technical Forum] Moving SSRS from one SQL machine to another

We are reorganizing some services.  One of the items being reoganizaed is the SSRS report server on SQL2005.  We want to move it to a different box.  I have followed instructions specific to this process that basically outline the following steps:

1.  Backup the "ReportServer" database from the source machine.

2.  Restore that database to the destination machine.

3.  Backup the SSRS Encryption Key from the source machine via the "Configure Report Server" console.

4.  Restore that same exported key (copied to the new machine from the old machine) via the "Configure Report Server" console on the new server.

(now deal with the Tessitura configuration items to point to the new server).

The problem occurs on step 4, when I try to restore the key.  I assure you I am pointing to the correct exported file and am entering the correct recovery password.  Error received:

ReportServicesConfigUI.WMIProvider.WMIProviderException: The feature: "Scale-out deployment" is not supported in this edition of Reporting Services. (rsOperationNotSupported)
   at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
   at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)

Both servers are running the same version of SQL2005 standard, SP2.  Anyone else received this error and come up with a solution?

Thanks!

Larry

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!