Secondary site cannot get SQL certificate from parent

I didn't find any answers from the related topics. So I have this issue in the hman.log. I have reinstall this server. Tried to install on a new server but I get this same issue. I am not sure where to go anymore. Please help

hman.log on child says

Cannot get SQL Certificate from site xxx

CheckParentSQLServerCertificate: Failed to get SQL certificate for site XXX

Sender on child

Registry indicates no outbox for the sender to scan

We have 0 active connections

Replmgr on child

Did not find any replication files

September 19th, 2012 4:51pm

What about replmgr.log, sender.log and rcmctrl.log on the parent site?
Free Windows Admin Tool Kit Click here and download it now
September 20th, 2012 6:33am

I had the exact same issue happen to me few days ago and finally had to open a case with MS. Something is wrong with the sql server service broker and the way certificates are sent.

First make sure you can telnet to 1433 and 4022 from Primary to Secondary and vice versa. If thats working fine, your sql port communication is fine.

Try removing the secondary site and adding it back. If the option to remove is not available in console, you will have to delete the secondary and then manually uninstall the secondary site. Try adding the secondary back again. Keen an eye on hman.log.

If same error,"CheckParentSQLServerCertificate" comes back, one last thing you can try is re installing the secondary site server with a different site code. (this i have heard worked for some one, true story ;))

I never was able to resolve this issue and wasted almost a month. Finally dropped the idea of installing a secondary and went with standalone DP's,MP's etc.

If the different site code trick works for you, then this could be a possible bug. Keep posted on how that goes. best of luck my friend.



September 21st, 2012 6:31am

Same problem here. Ports are fine.

I get this error on almost every secondary site I install. Any ideas?

Free Windows Admin Tool Kit Click here and download it now
October 20th, 2012 9:35am

I also had same issue on two secondary servers and was able to fix it by manually synch between primary and secondary(server which i had issue).

to re-synch manually between primary and secondary use stored procedure as shown below...I executed below command from primary database.As soon a executed below command replication started between primary and secondary and issue got fixed.

Exec spDrsSendSubscriptionInvalid 'Secondary 3 digit site code','Primary 3 digit site code','configuration data'

March 27th, 2013 12:42pm

Hi,

This sounds like the issue I am seeing also. See my thread.

Are you also able to run 'Replication Link Analyzer' from Monitoring, Database Replication?


Free Windows Admin Tool Kit Click here and download it now
March 27th, 2013 1:08pm

I also had same issue on two secondary servers and was able to fix it by manually synch between primary and secondary(server which i had issue).

to re-synch manually between primary and secondary use stored procedure as shown below...I executed below command from primary database.As soon a executed below command replication started between primary and secondary and issue got fixed.

Exec spDrsSendSubscriptionInvalid 'Secondary 3 digit site code','Primary 3 digit site code','configuration

March 27th, 2013 1:14pm

Exec spDrsSendSubscriptionInvalid 'Secondary 3 digit site code','Primary 3 digit site code','configuration data'
[...]
Can you confirm if above is correct and command line should be "Exec spDrsSendSubscriptionInvalid 'Secondary Site Code', 'Primary Site Code', 'Configuration Data'" ?


Looks identical (and valid) to me.
Free Windows Admin Tool Kit Click here and download it now
March 27th, 2013 1:28pm

yes...i used the below command and was able to fix the issue 

example - >  Exec spDrsSendSubscriptionInvalid 'SE1','PR1','configuration data'

SE1 is my secondary site code and PR1 is my primary site code.

March 27th, 2013 6:55pm

I get  this error with that.

ERROR Sending SSB Message from: ConfigMgrRCM_SiteP01 to ConfigMgrRCM_SiteS05 SQL Error: 50000 SQL Message: ERROR 50000, Level 16, State 1, Procedure spGetSSBDialogHandle, Line 58, Message: Route is not defined for target site with service name ConfigMgrRCM_SiteS05.

Msg 50000, Level 16, State 1, Procedure spRethrowError, Line 42

ERROR 50000, Level 16, State 1, Procedure spRethrowError, Line 42, Message: ERROR 50000, Level 16, State 1, Procedure spGetSSBDialogHandle, Line 58, Message: Route is not defined for target site with service name ConfigMgrRCM_SiteS05.

(1 row(s) affected)


Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2013 2:59pm

can you post the command which you  are trying to execute..?
April 22nd, 2013 3:58pm

Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2013 4:03pm

I have the same problem.

and secondary servers status remains as pending on the primary server

April 29th, 2013 2:18pm

looks interesting.... beacuse i am able to run the command without any errors.

Free Windows Admin Tool Kit Click here and download it now
April 30th, 2013 9:46am

you have to monitor the logs mentioned after having run this command.
April 30th, 2013 10:02am

I was having the same issues with my first two Secondary Sites.  Both failed the prereqs and I had to do a retry install due to IIS components not being automatically installed .  The third 2ndary site went in with out a hitch, but I preconfigured the IIS components ahead of time -  so I attribute it to the retry install.

I tried the sql script "Exec spDrsSendSubscriptionInvalid 'YXZ,'ABC','configuration data'" with no luck too- same error as as jamicon.  So I went the route of deinstalling the 2ndary site via ARP on the 2ndary site server and then deleted it from the 2012 CM console.  Reinstalled with new site codes and all went through and both problematic sites are now on line.

Free Windows Admin Tool Kit Click here and download it now
August 19th, 2013 4:54pm

Have seen this issue a couple of times and running the following query have worked for me: Exec spDrsSendSubscriptionInvalid "SEC","PRI","configuration data" 
September 26th, 2013 7:06pm

I had the same issue. Ended up being a firewall issue where the secondary site sql could not connect over the service broker port to the primary site server. Using telnet and PortQuery Utility to verify communication, issue was then resolved.
Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 3:12pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics