SSRS Error: The version of the report server database is either in a format that is not valid, or it cannot be read…

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 :).

About these ads

About Suresh Kumar D

Hardcore SQL Developer and aspiring Database Architect.
This entry was posted in SSRS. Bookmark the permalink.

9 Responses to SSRS Error: The version of the report server database is either in a format that is not valid, or it cannot be read…

  1. Jaco says:

    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

    • Ivan Cummings says:

      Hi… i have this problen, but inverted. how execute this query in sql server 2008. the instancy name is [ReportServer$FCIWAREHOUSE] and [ReportServer$FCIWAREHOUSETempDB]

  2. Adriano says:

    Thanks for the article, helped me a lot.
    Adriano-BRA

  3. Pingback: 2010 in review | Kirukkal a.k.a Scribbling

  4. Anam says:

    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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s