"Michael Cheng [MSFT]" wrote:

> Hi Tom,
>
> Welcome to use MSDN Managed Newsgroup!
>
> From your descriptions, I understood you would like to know what's the best
> way to move Report Server in SQL Server Reporting Server 2005. If I have
> misunderstood your concern, please feel free to point it out.
>
> Based on my knowledge, you can move a report server database to another SQL
> Server instance using any of the supported techniques for moving SQL Server
> databases from one computer to another. Moving the report server database
> disables the connection to the report server. After you move the report
> server database, you must reconfigure the connection information, which is
> stored as an encrypted value in the rsreportserver.confg file.
>
> Moving a Report Server Database to Another Computer
> http://msdn2.microsoft.com/en-us/library/ms156421.aspx
>
> You may also refer the article below for more detailed information
>
> Migrating Reporting Services
> http://msdn2.microsoft.com/en-us/library/ms143724.aspx
>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
>
> Sincerely yours,
>
> Michael Cheng
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>