• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1169
  • Last Modified:

Updating SQL Server 2008 Reporting Services to SP2

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
Ehab Salem
Asked:
Ehab Salem
  • 3
1 Solution
 
Ehab SalemIT ManagerAuthor Commented:
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
 
Umesh_MadapCommented:
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
 
Ehab SalemIT ManagerAuthor Commented:
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
 
Ehab SalemIT ManagerAuthor Commented:
I found no other choice. I installed SP2 and was completed fine.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now