Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Updating SQL Server 2008 Reporting Services to SP2

Posted on 2011-02-22
4
Medium Priority
?
1,148 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 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

OfficeMate Freezes on login or does not load after login credentials are input.
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
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…

971 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