Solved

Updating SQL Server 2008 Reporting Services to SP2

Posted on 2011-02-22
4
1,107 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 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
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 walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

617 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