In this scenario, we need to add the Reporting Services service to the existing SQL Server 2008 R2 SP2 instance from the ISO image first, and then apply the Service Pack 2 for SQL Server 2008 R2. For the services and features that have been updated to SP2
already, they will be ignored during the SP2 installation. We can see that from the "Select Features" page of the SQL Server 2008 R2 SP2 installation.
If you have any feedback on our support, please click
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.