Migrating reporting server database with SQL Server 2005 Standard

If you are moving reporting services to a brand new SQL Server machine (such as setting up a UAT environment or test server) then you may backup and restore the reporting server database from your production machine. You will probably then backup and restore the encryption keys. However you will probably get the error:

“Reporting server can’t be used as part of a scale-out deployment” or something along those lines.

Fear not! Because you aren’t using enterprise you need to remove the key for the old server from the config using:

rskeymgmt -l

and then

rskeymgmt -r

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>