Solved

Updating SQL Server 2008 Reporting Services to SP2

Posted on 2011-02-22
4
1,072 Views
Last Modified: 2012-05-11
We have an instance of SQL Server 2008 that was installed without the reporting services, then updated to SP2. I installed Reporting services from the original CD (no SP2). Now reporting services starts but once I logon to it I get a version mismatch error.
I want now to update reporting Services only to SP2 (without affecting the SQL server base installation which is already SP2).

How do I do that?
0
Comment
Question by:Ehab Salem
  • 3
4 Comments
 
LVL 14

Author Comment

by:Ehab Salem
ID: 34950876
The error I get is:

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.9.45'. (rsInvalidReportServerDatabase)
1
 
LVL 2

Accepted Solution

by:
Umesh_Madap earned 500 total points
ID: 34951781
hi you have to install the sp 2, while installing the SP2 u need to select the reporting servers and update sp2 for reporting services.
0
 
LVL 14

Author Comment

by:Ehab Salem
ID: 34951845
I did that, but features is also selected and I cannot de-select, it's dimmed. I do not want to change anything but the reporting svcs.
0
 
LVL 14

Author Comment

by:Ehab Salem
ID: 34991558
I found no other choice. I installed SP2 and was completed fine.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now