Problems installing Secondary Site - Link is being Configured

[benji]

I've been having some strange issues with getting Secondary Sites to work. Link is being configured ("Initializing data between parent site and child site")

 

Setup.

 

Primary Site

• Fresh Install
  
• Linked to Remote SQL server
  
• WIndows Firewall disabled (and ports 1433 and 4022 allowed)
  

 

Database Server

• SQL Server 2008 R2 CU4
  
• Firewall Disabled (and ports 1433 and 4022 allowed)
  
• Database running on port 1433
  

 

Secondary Site

• Firewall disabled (and ports 1433 and 4022 allowed)
  
• Installed Secondary Site via Primary Site Console (appears to have been successful)
  
• database running/listening on port 1433
  

 

The issue i'm having is with the database replication between the Primary Site and the Secondary Site. Link is being configured ("Initializing data between parent site and child site")

 

However: the "Child site to Parent Site Global State: is set to "Link Active"

It's just the Parent site to Child Site Global State: that is set as "Link is being configured"

 

 

The primary site computer account is a local admin on all 3 machines

The secondary site computer account is a local admin on all 3 machines

 

When i run the Replication Link Analyzer it suggests i reset the queued messages, however this has no effect nor does it's next step of reinitialize replication groups on site "XYZ"

Looking at the log file it creates the only thing i see that could be related is this message

 

"Publisher BNE does not have record or record is aborted for replication group Secondary_Site_Replication_Configuration. Re-initialize the group. "

 

 

Any ideas would be welcome

[benji]

Update:

 

 

Running: "SELECT name, protocol_desc, port, state_desc FROM sys.tcp_endpoints WHERE type_desc = 'SERVICE_BROKER'" on both the primary server database and the secondary server database confirms that SSB is running on 4022 for both of these servers.

 

Running: "select * from RCM_ReplicationLinkStatus" from the primary server database

 

Retuns the below result

 

PER BNE PER 21 3 2012-10-04 00:32:12.610 2 Active 2012-10-04 00:29:01.630 1 2012-10-04 08:23:30.560 NULL

PER BNE PER 22 3 2012-10-04 00:32:12.620 2 Active 2012-10-04 00:31:59.763 1 2012-10-04 08:25:58.400 NULL

PER PER BNE 21 3 2012-10-04 00:32:12.613 2 Active 2012-10-04 00:29:50.010 NULL NULL NULL

PER PER BNE 22 3 2012-10-04 00:32:12.623 2 Active 2012-10-04 00:33:53.413 NULL NULL NULL