SCCM Secondary Site SQL Replication Issue (DRS Issue)

When you see the SQL replication has been failed and try to run replication link analyzer and you get there is an DRS issue with database, try these steps,

Below command will help you to view all SQL replication status
EXEC spDiagDRS – Running this command in SQL Management Studio will show all filed of SQL Replication

If you see the the replication group is disable ot inactive follow the below steps,

• Run this command to remove To service entry from SSB_Dialogpool “delete from SSB_DialogPool where ToService like '%PRIMARYSITECODE' “
• On the Secondary Site create the below two files under C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box

1. Secondary_Site_Replication_Configuration.pub
2. Secondary Site Data.pub

• Now run EXEC spDiagDRS command again and check if all replications are active

Distribution Point Installation failed to install Error 0x800706BA

When you install SCCM distribution point you may get this error on distmgr.log DPConnection::ConnectWMI() – Failed to connect to servernameError 0x800706BA

This means that SCCM server is unable to connect to the WMI namespace on the target machine which is why the installation of distribution point is failing. You would also see an error which reads Failed to install DP files on the remote DP Error code=1722

Fix

Copy the smsdpprov.mof file into Distribution Point installation drive, you can find the smsdpprov.mof file under <drive:>\Program Files\Microsoft Configuration Manager\bin\X64 in your primary site server

Run the command prompt as administrator and execute the following command

mofcomp.exe smsdpprov.mof

If you still getting the same error run the below command,

netsh firewall set service remoteadmin enable

This command will allow remote user to execute / allow access the local firewall policy