Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Updating SQL Server 2008 Reporting Services to SP2

Posted on 2011-02-22
4
Medium Priority
?
1,126 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

719 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