Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Moving SQL 2000 reporting services

Author  Topic 

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2010-03-18 : 10:00:16
Folks
I am trying to move multitudes of reports from SQL 2000 Reporting services one server to SQL 2000 reporting services on another.

I consistently get this error.

he 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.51'. The expected version is 'C.0.6.43'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

Microsoft's explanation is as follows:
Explanation
This error occurs when the report server database is not the same version as the report server engine. This error can occur if you move components or modify your configuration (for example, moving a report server into a Web farm, and the existing report servers in the Web farm are a different version).


User Action
There are no database repair tools that you can use to modify the version of a database. You must run Setup to install a report server and create a report server database that has the same version. You can run rs.exe to copy data from one report server database to another. For more information, search for rs utility in Books Online.


It means nothing to me.
Can somebody help please?
thanks in advance


Regards
Paresh Motiwala
Boston, USA

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2010-03-19 : 09:42:48
here's the scoop
I applied sp1 for the reporting services and the error now changed to....

The report server installation is not initialized. Check the documentation for more information. (rsReportServerNotActivated) Get Online Help -2147159550


any clue....

Regards
Paresh Motiwala
Boston, USA
Go to Top of Page
   

- Advertisement -