locked
Secondary site - Install pending RRS feed

  • Question

  • I am trying to install my first secondary site. Its been almost a day and the status still says "Pending"

    When I check the hman.log on secondary server it says:

    CheckParentSQLServerCertificate: Failed to get SQL certificate for site XYZ

    I checked the certifcate under Protocols for ConfigMgr sec and I see Configmgr SQL Server Identification certificate that has an expiration year 2112, issued by the Secondary site server, Issued to secondary site server. 

    How can I troubleshoot this issue ?

    Monday, August 20, 2012 6:32 AM

Answers

  • Nope. Uninstalled the secondary site and just went with a distribution point. I had a case open with MS which did not get resolved and was tied to an open bug. 

    Check this thread as well

    http://social.technet.microsoft.com/Forums/en-US/configmanagerdeployment/thread/019cb2a2-e412-4e1e-b790-413005a20631

    Shiva

     

    Saturday, December 1, 2012 12:39 AM

All replies

  • Check if the replication is working fine (Monitoring node -> Database Replication) and rcmctrl.log + sender.log


    Torsten Meringer | http://www.mssccmfaq.de

    Monday, August 20, 2012 7:12 AM
  • There is nothing under Database replication on the console. I did not find out any errors on the primary site.

    hman.log on secondary site says

    "SMS-Site-XYZ could not be created, error code = 5."

    Wait for site control changes for maximum 3600 seconds... SMS_HIERARCHY_MANAGER 8/20/2012 10:42:30 AM 2052 (0x0804)

    Update site server active directory informtion into DB SMS_HIERARCHY_MANAGER 8/20/2012 10:42:37 AM 2052 (0x0804)

    Time to verify if the parent[XYY] sql server certificate is still valid on site [XYZ] sql server. SMS_HIERARCHY_MANAGER 8/20/2012 10:42:37 AM 2052 (0x0804)
    Cannot get SQL Certificate from Site XYY. SMS_HIERARCHY_MANAGER 8/20/2012 10:42:37 AM 2052 (0x0804)
    CheckParentSQLServerCertificate: Failed to get SQL certificate for site XYY SMS_HIERARCHY_MANAGER 8/20/2012 10:42:37 AM 2052 (0x0804)
    Wait for site control changes for maximum 3600 seconds... SMS_HIERARCHY_MANAGER 8/20/2012 10:42:37 AM 2052 (0x0804)

    replmgr.log on Secondary site - Did not see any errors

    Scanning normal priority outbound replication directory. SMS_REPLICATION_MANAGER 8/20/2012 11:15:15 AM 400 (0x0190)
    Did not find any replication files. SMS_REPLICATION_MANAGER 8/20/2012 11:15:15 AM 400 (0x0190)
    Scanning low priority outbound replication directory. SMS_REPLICATION_MANAGER 8/20/2012 11:15:15 AM 400 (0x0190)
    Did not find any replication files. SMS_REPLICATION_MANAGER 8/20/2012 11:15:15 AM 400 (0x0190)
    There are jobs to site XYY of the same priority waiting to be sent, won't send this batch. SMS_REPLICATION_MANAGER 8/20/2012 11:15:15 AM 400 (0x0190)
    Waiting for outbound replication files... SMS_REPLICATION_MANAGER 8/20/2012 11:15:15 AM 400 (0x0190)

    The secondary server is part of the the SMS_Sitetositeconnection on the primary. Not sure what else to check.


    • Edited by Shiva P Monday, August 20, 2012 6:23 PM
    Monday, August 20, 2012 6:23 PM
  • I restarted SQL Servicers on secondary site and i see this

    CheckParentSQLServerCertificate: Failed to get SQL certificate for site XYY               SMS_HIERARCHY_MANAGER       8/20/2012 10:42:37 AM  2052 (0x0804)

    Wait for site control changes for maximum 3600 seconds...            SMS_HIERARCHY_MANAGER               8/20/2012 10:42:37 AM  2052 (0x0804)

    *** set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy;               SMS_HIERARCHY_MANAGER       8/20/2012 11:40:25 AM  2660 (0x0A64)

    *** [08S01][10054][Microsoft][SQL Server Native Client 10.0]TCP Provider: An existing connection was forcibly closed by the remote host.   SMS_HIERARCHY_MANAGER       8/20/2012 11:40:25 AM               2660 (0x0A64)

    *** set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy;               SMS_HIERARCHY_MANAGER       8/20/2012 11:40:25 AM  2660 (0x0A64)

    *** [08S01][10054][Microsoft][SQL Server Native Client 10.0]Communication link failure               SMS_HIERARCHY_MANAGER       8/20/2012 11:40:25 AM  2660 (0x0A64)

    *** Failed to connect to the SQL Server.  SMS_HIERARCHY_MANAGER       8/20/2012 11:40:25 AM               2660 (0x0A64)

    Update site server active directory informtion into DB       SMS_HIERARCHY_MANAGER       8/20/2012 11:40:46 AM       2052 (0x0804)

    Processing 65537.SQR file.            SMS_HIERARCHY_MANAGER       8/20/2012 11:40:46 AM  2052 (0x0804)

    CheckSQLServiceRestart : SQL Server has been restarted, successfully checked and applied security change. SMS_HIERARCHY_MANAGER       8/20/2012 11:40:47 AM  2052 (0x0804)

       Time to verify if the parent[XYY] sql server certificate is still valid on site [XYZ] sql server.               SMS_HIERARCHY_MANAGER       8/20/2012 11:40:47 AM  2052 (0x0804)

    Cannot get SQL Certificate from Site XYY.               SMS_HIERARCHY_MANAGER       8/20/2012 11:40:47 AM         2052 (0x0804)

    CheckParentSQLServerCertificate: Failed to get SQL certificate for site XYY               SMS_HIERARCHY_MANAGER       8/20/2012 11:40:47 AM  2052 (0x0804)

    Wait for site control changes for maximum 3600 seconds...            SMS_HIERARCHY_MANAGER               8/20/2012 11:40:47 AM  2052 (0x0804)

    Update site server active directory informtion into DB       SMS_HIERARCHY_MANAGER       8/20/2012 11:40:52 AM       2052 (0x0804)

    Time to verify if the parent[XYY] sql server certificate is still valid on site [XYZ] sql server.               SMS_HIERARCHY_MANAGER       8/20/2012 11:40:52 AM  2052 (0x0804)

    Cannot get SQL Certificate from Site XYY.               SMS_HIERARCHY_MANAGER       8/20/2012 11:40:52 AM         2052 (0x0804)

    CheckParentSQLServerCertificate: Failed to get SQL certificate for site XYY               SMS_HIERARCHY_MANAGER       8/20/2012 11:40:52 AM  2052 (0x0804)

    Monday, August 20, 2012 6:46 PM
  • Make any progress on this one Shiva?

    Thursday, November 22, 2012 4:07 PM
  • Nope. Uninstalled the secondary site and just went with a distribution point. I had a case open with MS which did not get resolved and was tied to an open bug. 

    Check this thread as well

    http://social.technet.microsoft.com/Forums/en-US/configmanagerdeployment/thread/019cb2a2-e412-4e1e-b790-413005a20631

    Shiva

     

    Saturday, December 1, 2012 12:39 AM
  • Nope. Uninstalled the secondary site and just went with a distribution point. I had a case open with MS which did not get resolved and was tied to an open bug. 

    Check this thread as well

    http://social.technet.microsoft.com/Forums/en-US/configmanagerdeployment/thread/019cb2a2-e412-4e1e-b790-413005a20631

    Shiva

    Handy to know thanks!

    If it's a bug and it didn't go anywhere, could I ask you to file a DCR on Connect? This goes to the product group, and looked over. You will need to find the Configuration Manager home page on Connect then file there. Really helps.

    Saturday, December 1, 2012 2:14 PM