Link Failed with Secondary site Database

[jorlando]

I wanted to share a problem I had recently that was difficult to diagnose, but simple to resolve. My secondary site was having database replication issues. The symptoms were clients assigned to the secondary site were unable to download and run packages. Looking at the client logs the issue was there was no reply from the MP with content location. So the clients could not get a location to download content from.

 

Under Monitoring and Database Replication the link showed Link Failed and Link has Failed.

 

On the Primary Site the rcmctrl.log showed no errors, but on the secondary site the rcmctrl.log had the following error:

Launching 2 sprocs on queue ConfigMgrDRSQueue and 0 sprocs on queue ConfigMgrDRSSiteQueue. SMS_REPLICATION_CONFIGURATION_MONITOR

The asynchronous command finished with return message: [A .NET Framework error occurred during execution of user-defined routine or aggregate "spDRSActivation": ~~System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. ---> System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlConnectionFactory' threw an exception. ---> System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlPerformanceCounters' threw an exception. ---> System.MethodAccessException: Attempt by method 'System.Configuration.TypeUtil.CreateInstanceRestricted(System.Type, System.Type)' to access method 'System.Diagnostics.SwitchElementsCollection..ctor()' failed. ---> System.Security.SecurityException: Request failed… [truncated for readability]

This issue is caused by MS13-052 (KB2840628) and Microsoft has released a hotfix, KB2872041, for the issue.

Here is a link:

http://blogs.technet.com/b/configmgrteam/archive/2013/07/17/issues-reported-with-ms13-052-kb2840628-and-configmgr.aspx