rsInvalidReportServerDatabase

rsInvalidReportServerDatabase

• WestAustinite

  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

  
  
  

• TJB77494

  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.
  
  

• nukolai

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

• erb54238

  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
  
  

• JonTec7

  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.
  
  
  
  

• AmolK

  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
  
  

• chrisewers

  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
  
  
• rsInvalidReportServerDatabase