Help in Moving RS databases to another machine

We plan on moving our sql 2000 db's to a sql server 2005 box this week.

What's the best way to point RS to the new database machine

I'm not extremely familiar with Reporting Services and would like to know are there any "gotchas" in doing this

Thanks



Answer this question

Help in Moving RS databases to another machine

  • Suma Sushilendra

    1. Create a shared datasource in reporting services.

    2. Assign the reports to that shared datasource and thats it.



  • Aakarsh

    If you mean you want to move the catalog database of RS (ReportServer/ReportServerTempDB) to another SQL instance, please check out the following KB article:

    How to move a Reporting Services database from a computer that is running Reporting Services to another computer
    http://support.microsoft.com/ id=842425


  • Don Jefe Leone

    That's gotta be the fastest response I've ever got from a user group. I'm on my way out the door right now but will investigate further tomorrow.

    Thanks.


  • ObieOne

    I'm having a problem changing the Report Server connection. I have Reporting Services installed on MachineA. I've moved the ReportServer and ReportServerTempDB from MachineB to MachineC. Now I need to update SQLRS on MachineA to connect to MachineC instead of MachineB.

    I ran the command line: RSConfig c [-s servername] [-d databasename] [-a authmethod] [-u username] [-p password] [-t]

    and I get this:

    The encrypted value for Configuration/Service/UnattendedExecutionAccount/Domain in the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config file cannot be decrypted.

    What step am I missing


  • Brad Radaker

    Please mark the post as an answer if its correct.

  • Help in Moving RS databases to another machine