Last week I had to install SSRS 2008 R2 on a machine which already has SSRS 2008. I installed the R2 as a named instance pointing to the SQL 2008 DB and choose the option “Install but do not configure”.
Then I configured the R2 to use the existing DB (i.e. that of SSRS 2008). The report server configuration wizard did not give any error.
After configuring, when I tried to access the Report Server thru browser I got the following error from both the instances.
SSRS 2008 thrown an error like “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 ‘147’. The expected version is ‘C.0.9.45’. (rsInvalidReportServerDatabase)”
whereas SSRS 2008 R2 thrown an error “The report server installation is not initialized. (rsReportServerNotActivated)”
Some forums suggested that this is because report server configuration is not proper. I opened up the report server configuration and checked the DB connections for both instances. Everything looked fine but the error persisted.
I understood that I screwed my SSRS by pointing two instances , which are of different versions, to a DB. So using report configuration wizard, I created two set of databases and assigned them to respective SSRS instances. Now both of them works fine.
Only issue is that I could not retrieve the RDLs from old report server DB. Anyway, it is my DEV instances and I have the code base :).
Kirukkal a.k.a Scribbling 
update A
set a.ServerVersion = ‘C.0.9.45’
from [ReportServer].dbo.[ServerUpgradeHistory] a
where a.ServerVersion = CAST(147 as nvarchar(3))
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 ‘147’. The expected version is ‘C.0.8.54’. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase) (rsRPCError)
For resolving this error i tried using the solution you provided.
I updated the version to ‘C.0.8.54’. that solved above problem.
Now while browsing, i can access parent page, but when i navigate towards further child pages from parent page i get below error.
An internal error occurred on the report server. See the error log for more details. (rsInternalError)
Procedure or function ‘CreateSession’ expects parameter ‘@SiteZone’, which was not supplied.
Your help appreciated on urgent basis.
Thanks.
Vimal
Vimal Can you post your solution Please.
Thanks,
Priya
Hi… i have this problen, but inverted. how execute this query in sql server 2008. the instancy name is [ReportServer$FCIWAREHOUSE] and [ReportServer$FCIWAREHOUSETempDB]
Can you tel me the solution what u have done this for error. Still the problem exist for me.
Thanks,
Priya.
Thanks for the article, helped me a lot.
Adriano-BRA
Pingback: 2010 in review | Kirukkal a.k.a Scribbling
How do I set up my own API?
Can you provide more information on your request?
Thanks
Hi,
I have done the following steps to migrate SQL Server 2005 reporting services to a new SQL Server 2008 R2 reporting services
1.Backed up reportserver & reportServerTempdb databases in sql server 2005 reporting services
2.Back up the encryption key in sql server 2005 reporting services
3.Install a new reporting services instance of SQL Server 2008 R2 x64 and applied SP1 on brand new Windows Server 2008 R2 SP1 x64
4.Restored the reportserver & reportServerTempdb databases in sql server 2008 R2 SP1 instance from the backups of step1
5.Configured the reporting services 2008 R2 using reporting services configuration manager
6.In reporting services manager, in Database tab, I have selected the option “choose an existing database” called reportserver(which was restored from sql server 2005)
7.Everything is successful in eporting services manager except the encryption key restore failed
Now, when I try to open the url http://servername/reportserver, I’m getting the below error:
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.8.43’. The expected version is ‘147’. (rsInvalidReportServerDatabase)
Please advcie
Did you try Jaco’s suggestion?
I have a same problem and trying to apply Jaco’s suggestion. However, It seems that I do not have
the table dbo.[ServerUpgradeHistory] ??