Where can I find instructions for upgrading SQL Server 2008R2sp1 where Reporting Services is integrated with Sharepoint 2010? I'm just not seeing this topic covered online. We have Reporting Services on a separate server from the Sharepoint SQL Server. Both are SQL Server 2008R2 sp1. Reporting Services is configured with Sharerpoint and it all is working.
We want to add service pack 3. Do I have to add it to the SQL on both servers? That is, do they have to be the same? Thanks very much for any help.