TameYourCloud.com – By Paul Sanders

Hi All,

Over the past couple of days I have been having a database replication issue with SCCM 2012 SP1 CTP2.

** Please note, CTP2 isn’t ready for production, and modifying the database directly is not supported by MS. I have raised this issue with MS as a possible bug. **

I was in the process of building a multiple forest SCCM hierachy that has two primary sites that report into a CAS. The setup wasn’t anything out of the ordinary, so my basic setup was:

Server Configuration:

MS-SCCMCAS01.ms.local – CAS – Central Administration Site in MS.local.
MS-SCCMPOC01.ms.local – POC – Primary Site in MS.local.
MS-SQL01.ms.loca – Multiple Instance SQL Server in MS.local. This hosted both CAS and POC Databases in their relative instances.

MS-SCCMDEV01.ms.local – DEV – Primary Site in AD.local. This also had a dedicated local SQL instance.

As soon as I started to check the replication status within monitoring, I noticed CAS to POC replication was showing
as Failed. After running a Replication Link Analysis, I recieved the following error message:

Detail Name=”result” Value=”Service broker route ConfigMgrBGBRoute_Local is missing or has incorrect address
for service ConfigMgrBGB_SitePOC. Expected address LOCAL.”

After some extensive research, the resolution came down to be Service Broker Routes within SQL. SBRs have taken over
most of the replication traffic in an SCCM hierachy in 2012.

When I logged into the relevant SQL instances, I made my way into the ConfigMgr databases and had a look into the
available routes.

As you can see, the Broker Route ‘ConfigMgrBGBRoute_Local’ is missing. So to create a new one, simply right click
and choose ‘New Route…’. This will give you an SQL query that will need modifying with the correct syntax.

To get my installation working, I had to run the following query on the CM_POC database:

CREATE ROUTE ConfigMgrBGBRoute_Local
AUTHORIZATION dbo
WITH
SERVICE_NAME = 'ConfigMgrBGB_SitePOC',

ConfigMgrBGB_SiteTEN.


I then had to do the reverse on the CM_DEV database at the opposite end. Once modified, and re-running the Link analyser, everything started replicating again.

=========================================================================
[Disclaimer]
This post is my own work and does not have any connection with my employer.
Following any of the information in these posts are at your own risk. TameYourCloud do not accept any responsibility for any issues that may arise.

[Copyright Notice]
This content is owned by Paul Sanders from TameYourCloud.com. This cannot be copied or distributed without his express permission. A simple quotation for up to 2 sentances maybe used, but a link to the original post must be provided.

Share and Enjoy