Error using Reporting services

Question

Error using Reporting services

bideveloper

SSC Journeyman

Points: 78
More actions
February 8, 2006 at 3:26 am

#167088

Greetings,
Iam new to reporting services. When I try to launch http:\\localhost\reports
I get the following 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 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)
Please help
Thanks/Regards

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Dave Klug SSCertifiable Points: 5811 More actions · Answer 1

It sounds like you created a new RS database and then did a SQL import of the report server from an existing RS installation? If this is the case, it sounds as if the old RS installation was running with Service Packs the new installation is missing.

Verify the new server has the same service packs as the old and this should fix the problem.

Cesar-134342 Ten Centuries Points: 1319 More actions · Answer 2

Seems to me that the account that is starting up the IIS server does not have permissions to read the ReportServer database.

In Enterprise Manager, open the ReportServer DB, go to Roles, and check the role "RSExecRole". In my case, I have "PCNAME\ASPNET" and "NT AUTHORITY SYSTEM". These are the only two accounts that require access to this role, asuming that you're using XP or W2K3, and selected the "NT AUTHORITY\NETWORK SERVICE" account to startup the RS services.

More likely the computername\ASPNET account is not mapped to this role. Add it and that should fix it.

Let us know if works.

bideveloper SSC Journeyman Points: 78 More actions · Answer 3

I configued my IIS to get away from the problem. Now Iam getting the following 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 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase) Get Online Help".

iam unable to create a report database using Report server configuration manager. It throws an error

"We were unable to create requested database script "

Cesar-134342 Ten Centuries Points: 1319 More actions · Answer 4

Do you have the ReportServer and ReportServerTempdb databases created already or not?.

gyan sada SSC Rookie Points: 29 More actions · Answer 5

I resolved the error by doing the following.

1. modifying the Log On as account for SQL Server Reporting Services to Local System account.

2. Verify you have created new database "ReportServer" in Configure Report Server\Database Setup.

-gyan_sada1

Paul Yearron SSC Veteran Points: 294 More actions · Answer 6

Hi, we are having a similar error. Initially we had SQL server 2000 box SSRS 2005 installed on it. We are now trying to connect a windows 2003 server to it.

On initialisation we get the following.

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.54'. The expected version is 'C.0.8.43'. To continue, update the version of the report server database and verify access rights.

We have tried two different W3K servers and the error message is the same on both.

We found what we thought would be a fix to this, which was a script which updates the database version. However we need to run this script manually each day as for some reason the database version reverts back to C.0.8.43 overnight.

If anyone can shed any light on this it would be a great help.

Thanks.