SCCM 2012 upgrade error pre-req: [Failed]:No Active MP Replica detected

TECHSANTA
TECHSANTA used Ask the Experts™
on
hello SCCM guru's!

We are upgrading to SCCM 2012 R2 1810. However, the pre-req check fails on here: [Failed]:No Active MP Replica detected. (We do not even have a MP replica.)

All else passes. But it will not allow upgrade without resolving that error.

Any ideas on how to get past that?

Thank you for your assistance!

-Mack
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike TLeading Engineer

Commented:
Hi,

It is checking that you DON'T have that. Has anyone tried in the past??

Check the log ConfiMgrPrereq.log on the site server for more info.

The full list of checks it runs through is here:
https://www.anoopcnair.com/list-of-sccm-cb-prerequisite-checks-via-configmgrprereq/

Mike

Author

Commented:
Hi Mike

Thanks for your reply.

Yes, it is checking that it does not have that. And that check is failing. And it's preventing the upgrade to 1810. We do not have an MP Replica. All the other checks pass just fine.

I check the ConfiMgrPrereq.log, and it states the same thing. Must be some corruption somewhere.

Can you think of any way to disable that one "Active MP" check? Or any other ideas on how to make that "Active MP" check pass?

Thank you so much!

-Mack
Mike TLeading Engineer

Commented:
Hi,

The check must be seeing something on the SQL side is my guess. Read the guide on how to set up a replica and make sure you do NOT have anything similar:
https://docs.microsoft.com/en-us/previous-versions/system-center/system-center-2012-R2/hh846234(v=technet.10) 

I'm not saying  you have setup a replica, but rather you may have set something in SQL that makes the check trip up and think that you do!

Do you see this (or something similar): "Active Replica MP; Error; Configuration Manager has detected an active MP Replica on this site. Please deactivate this MP before continuing upgrade, For more information refer to: http://go.microsoft.com/fwlink/?LinkId=271922".
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

Author

Commented:
I fixed it. The problem was one of my fine co-workers removed me from SQL sysadmin permissions. This made it so I could not see the publications. Ugh!

Thank you for your help!!
I fixed it. The problem was one of my fine co-workers removed me from SQL sysadmin permissions. This made it so I could not see the publications. Ugh!
Mike TLeading Engineer

Commented:
Well I knew it was SQL related, but didn't think of that! Glad you got it fixed.

Author

Commented:
Thank you for your kind help! I should have guessed my teammates would do something like that. They are less than trustworthy.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial