Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / September 2007

Tip: Looking for answers? Try searching our database.

RS Repository database version is dorked up, named instance has higher number than base instance, now can't access it.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve MunLeeuw - 23 Oct 2006 18:45 GMT
I installed a named instance but can't upgrade the database.  The found
version is higher than the expected version.  I read some blogs and it's
probably related to sp1.  The config tool for the named instance gives me
all green but when I try to access the 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 'C.0.8.43'.
The expected version is 'C.0.8.40'. To continue, update the version of the
report server database and verify access rights.
(rsInvalidReportServerDatabase) Get Online Help

           Steve MunLeeuw
Steve MunLeeuw - 23 Oct 2006 18:52 GMT
My bad, not everything is green, Initialization is red and gives me the
following error when clicking on it.  What did I do to get in this
situation?

---------------------------
Reporting Services Configuration Manager
---------------------------
There was an error while switching panels. The most likely cause is an error
retrieving WMI properties. The exception details are:

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

Steve MunLeeuw

>I installed a named instance but can't upgrade the database.  The found
>version is higher than the expected version.  I read some blogs and it's
[quoted text clipped - 8 lines]
>
>            Steve MunLeeuw
Michael Abair - 23 Oct 2006 20:20 GMT
Excerpt from http://blogs.msdn.com/lukaszp/

When you upgrade SQL Server 2005 to SP1 and you are running Reporting
Services, you may start to get the following error message:

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

First the solution:

Got to Start à All Programs à Microsoft SQL Server 2005 à Configuration
Tools à Reporting Services Configuration

Connection to your report server on the connection dialog.  Navigate to the
Database Setup tab (left navigation pane, 6th from the top).

Click the Upgrade button on the Database Connection page.

Provide credentials that are members of the sysadmin SQL server group.

After you finish this, you should be good to go.

Now let's talk about what setup is doing under the covers and how to avoid
getting in this situation:

In SP1 we had to change the report server database format.  This meant that
during service pack installation we have to connect to the report server
database and upgrade the report server database.

When you run SP1 setup, by default we use the credentials of the user
running setup to connect to upgrade the report server database.  Sometimes
this does not work:

1)      when the user running setup does not have sysadmin group membership
in SQL Server

2)      when the report server database is hosted on a remote computer, if
you're running as a local user, your user cannot access the remote computer
to upgrade the report server database

3)      when the report server database is inaccessible - the sql server is
stopped or you cannot connect to the database for whatever reason.

You can change the credentials we use in one of two ways:

A)    In the UI you can select the report server database and click to
configure specific credentials

B)     On the command line you can specify the /rsupgradedatabaseaccount and
/rsupgradepassword switches

There is one case in which you cannot supply credentials.  If you run SP1
upgrade using Microsoft Update, the setup runs under a local account. This
account may not have permissions as described above.  As such, it is more
likely to cause you to encounter the error above.

Signature

Michael Abair
Michael Abair
Programmer / Analyst
Chicos FAS Inc.

> My bad, not everything is green, Initialization is red and gives me the
> following error when clicking on it.  What did I do to get in this
[quoted text clipped - 29 lines]
>>
>>            Steve MunLeeuw
Steve MunLeeuw - 23 Oct 2006 20:27 GMT
Thanks Michael,

I didn't apply SQL SP1 agian after installing the named instance.  The
scripts to create the new database were probably for version 'C.0.8.43', but
the newly installed components were for 'C.0.8.40' .  The SPI updated the
components to 'C.0.8.43' and the error went away.

Steve MunLeeuw

> Excerpt from http://blogs.msdn.com/lukaszp/
>
[quoted text clipped - 88 lines]
>>>
>>>            Steve MunLeeuw
Senthil - 12 Sep 2007 14:04 GMT
SQL Server 2005 SP1 Reporting Services database expected version is 'C.0.8.43' problem

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

From http://www.google.co.in/search?hl=en&q=The+version+of+the+report+server+database
+is+either+in+a+format+that+is+not+valid,+or+it+cannot+be+read.+The+found+versio
n+is+'C.0.8.40'.+The+expected+version+is+'C.0.8.43'.+&btnG=Google+Search&meta


Posted via DevelopmentNow.com Group
http://www.developmentnow.com
Chris Alton [MS] - 28 Sep 2007 19:26 GMT
Open the SRS config tool and go to the Database Setup section. Then connect
to the database in question.
After you connect click the "Upgrade" button and follow the instructions.
Signature

SQL Server Developer Support Engineer

> SQL Server 2005 SP1 Reporting Services database expected version is 'C.0.8.43' problem
>
[quoted text clipped - 4 lines]
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.