RS Restore Version Conflict

We are attempting to dry run a SQL 2000 to SQL 2005 upgrade. We build a
server in a test lab with reporting services 2000, SP1 successfully. Backed
up our production (reporting services 2000 SP1) ReportServer databases and
restored to the test lab server. Now we get the following error in report
manager:
The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'C.0.6.54'. The expected
version is 'C.0.6.51'. To continue, update the version of the report server
database and verify access rights. (rsInvalidReportServerDatabase) Get Online
Help
How do I troubleshoot this? I'm not finding anything in online help. Thank
you,Hi Brent,
Welcome to use MSDN Managed Newsgroup!
The error message indicates the database you used to attach is backuped
from a Reporting Services SP2 but you are attaching it to a Report Services
SP1.
You should select the correct version database for Reporting Services.
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.|||I am having a similar problem moving a RS db from 32 bit sql to 64 bit sql.
Could you please extrapolate on "You should select the correct version
database for Reporting Services."
--
MCSD
"Michael Cheng [MSFT]" wrote:
> Hi Brent,
> Welcome to use MSDN Managed Newsgroup!
> The error message indicates the database you used to attach is backuped
> from a Reporting Services SP2 but you are attaching it to a Report Services
> SP1.
> You should select the correct version database for Reporting Services.
>
> 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.
>|||Hi,
Thanks for your question but it is not exactly the same as original one.
If you want to move the Report Server database, it would be recommended to
use 32bit SQL Server's database to restore the 32bit SQL Server's database.
Everything should be match.
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.|||We are migrating from a 32 bit SQL server to a 64 bit. I cannot find any
papers on how to do this migration, therefore I detached the DB from 32bit
and reattached to 64 bit server. After reattaching is when I get the error.
Reattaching to 32 is pointless.
--
MCSD
"Michael Cheng [MSFT]" wrote:
> Hi,
> Thanks for your question but it is not exactly the same as original one.
> If you want to move the Report Server database, it would be recommended to
> use 32bit SQL Server's database to restore the 32bit SQL Server's database.
> Everything should be match.
>
> 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.
>
>|||Just a guess, but try the SSIS wizards on the 64bit server to move the
databases from a 32bit server.
Cheers
Chris
Aco wrote:
> We are migrating from a 32 bit SQL server to a 64 bit. I cannot find
> any papers on how to do this migration, therefore I detached the DB
> from 32bit and reattached to 64 bit server. After reattaching is when
> I get the error. Reattaching to 32 is pointless.