rsInvalidReportServerDatabase

We are getting the following error when we try to deploy SQL report on to the reporting server
the 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)

We are using SQL server 2005 CTP and .Net 2005 beta 2.
the OS is Win xp and the reporting server is the local host.

Thanks a lot in advance.

Thanks & Regards

Jayan

You can use the Reporting Services Configuration tool (available from Start -> SQL Ctp -> Configuration Tools) to look at the configuraiton properties for the report server.

Navigate to the database page. If there is a database configured, and you get this error, chances are you somehow chose to use an existing database. If you tried to upgrade from a previous RS deployment, this might occur. The May CTP will support upgrade from SQL 2000 RS to the May CTP version.

I would recommend creating a new report server database and confguring the report servet use it. The config tool lets you do that.

-Lukasz

|||we used the reporting service config tool to configure the service also we created new database to be used by the reporting service(both reportingservice & reportingservicetemp) ew had also configured the reporting service to use SA account, tried with windows security and also with the service crediantials. still we are getting the same error, when we try to deploy reporting project. we get the same error when we try to create a new data source from the report manager web application.

Thanks a lot for your help.
Thanks & regards

Jayan|||Hi Lukasz,
Thanks for your help, we deleted the earlier databases, then created new using the tool. still when we tried it gave the same error. then we restarted the service and everything worked fine.

Thanks a lot for your help.

Thanks & Regards

Jayan.|||I actually think we fixed that bug for the June CTP. It was a problem where we were not picking up configuration file changes that affect the windows service DSN.

This led to problems with backing up the symmetric key. It could also, now that I think about it, cause problems publishing reports due to the need to encrypt information in the report datasources.

Good to hear you're up and running.
-Lukasz|||i got the same err while deploying with sql 2005 reporting services:

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.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

the fix is:
1. In reporiting services configuration manager-> database setup, make sure you have the correct reporting database selected. In this case it will throw the same err when you try to initialize the reporting services.|||Hi,

I had the same problem you reported, and fixed it by creating a new database.

now when I navigate to http://localhost/reports

I get the following error:

XML Parsing Error: not well-formed
Location: http://moor-6ftylksqxm/reports/
Line Number 1, Column 2:<%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePage" %>
-^

any idea what that's about?

regards

Helen|||I'm experiencing the same problem. Is this more of an IIS issue? Any help would be appreciated.

Thanks!sql