SQL Service Broker and MSDB wrt ConfigMgr DRS

Hi Folks, I came across this weird issue where the messages were stuck in the sys.transmission_queue and we do not see the to_broker_instance column for these messages. It was empty, meaning the message was not yet able to identify the routing service at the receiving end. The rest other sites working meant we had the…

2

ConfigMgr 2012 DRS – Troubleshooting FAQs

Hi Folks, Thanks for your feedback on the previous DRS unleashed post. As promised, this post would take you in the deep analysis and troubleshooting of the ConfigMgr 2012 Data replication services issues. I have tried putting up the format as a Q and A format to answer the questions that came to my mind…

24

ConfigMgr 2012: DRS and SQL service broker certificate issues

Hi Folks, Today's post is about the much talked about feature on ConfigMgr 2012- Data Replication Service (DRS). The replication mechanism internally uses SQL Service broker and I am discussing the three common issues with SSB that can stop the replication.   Issue 1: In the SQL error log we see the following: 'Connection handshake…

17