locked
SQL Server Service Broker configuration is not valid RRS feed

  • Question

  • Hi,

    Trying to deploy a secondary site and seeing 'Link is being configured; for Link State and 'Initializing data between the parent site and child site' for Description. This has been like that since yesterday and I am clearly convinced something is not right.

    Searching for answers, I was able to find and run 'Replication Link Analyzer' and right away it said 'SQL Server Service Broker configuration is not valid on <DB_SERVER\INSTANCE1>'.

    Already spoke to DBA guys who say they fixed this issue by enabling the broker on the SCCM database. Is there anything else I may have missed?#


    Wednesday, March 27, 2013 11:16 AM

Answers

  • I've Run the SQL query below, removed the secondary site role, rebooted servers and re-installed the secondary site role which fixed it for me:

    CREATE ENDPOINT [ConfigMgrEndpoint]
                    AUTHORIZATION <account>
                    STATE=STARTED
                    AS TCP (LISTENER_PORT = 4022, LISTENER_IP = ALL)
                    FOR SERVICE_BROKER (MESSAGE_FORWARDING = ENABLED
    , MESSAGE_FORWARD_SIZE = 5
    , AUTHENTICATION = CERTIFICATE [ConfigMgrEndpointCert]
    , ENCRYPTION = REQUIRED ALGORITHM AES)
    Go

    • Marked as answer by Lats Wednesday, March 27, 2013 3:40 PM
    Wednesday, March 27, 2013 3:38 PM

All replies

  • Port 4022 in the firewall and disable any dynamic ports on the secondary site SQL config.

    Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund | Mastering ConfigMgr 2012 The Fundamentals

    Wednesday, March 27, 2013 11:51 AM
  • No firewall is enabled.

    I have also disabled dynamic ports on the secondary site.

    If it is any help, I keep seeing these in ReplicationAnalysis.xml:

    Name="isServiceBrokerConfigCorrect" Value="False" /><Detail

    Name="isServiceBrokerRouteConfigCorrect" Value="True" /><Detail

    Name="isServiceBrokerLoginConfigCorrect" Value="False" /><Detail

    Wednesday, March 27, 2013 12:17 PM
  • I've Run the SQL query below, removed the secondary site role, rebooted servers and re-installed the secondary site role which fixed it for me:

    CREATE ENDPOINT [ConfigMgrEndpoint]
                    AUTHORIZATION <account>
                    STATE=STARTED
                    AS TCP (LISTENER_PORT = 4022, LISTENER_IP = ALL)
                    FOR SERVICE_BROKER (MESSAGE_FORWARDING = ENABLED
    , MESSAGE_FORWARD_SIZE = 5
    , AUTHENTICATION = CERTIFICATE [ConfigMgrEndpointCert]
    , ENCRYPTION = REQUIRED ALGORITHM AES)
    Go

    • Marked as answer by Lats Wednesday, March 27, 2013 3:40 PM
    Wednesday, March 27, 2013 3:38 PM