We have one primary server and two secondaries (no cas).
I recently successfully upgraded the primary to R2.
When trying to upgrade the first secondary, it failed the pre-req check because the initial SCCM 2012 SP1 install only installed SQL Express 2012 RTM on the secondary.
So I installed SQL 2012 SP2 patch on the secondary, after which the replication failed. Its important to note the network connection is international and not reliable between this secondary and the primary.
Is there anything I need to do to the next secondary, before patching SQL (before i can upgrade it)? Do i need to stop the SMS service? Stop the SQL service?