none
The Service Broker endpoint is in disabled or stopped state.

    Question

  • We are getting the following error message continuously in SQL Server error log.

    "The Service Broker endpoint is in disabled or stopped state."

    We have Always on Feature enabled on the SQL Server 2012 instance with version(11.00.2100).

    any idea what could cause these messages to be logged in SQL Server error log. Will there be any issue in future because of this?

    Thanks in advance.

    Regards,

    Gayaz

    Tuesday, January 07, 2014 11:11 AM

All replies

  • Is this message appearing in the initiator or target instance SQL log?

    Are messages being sent, received and acknowledged or are they stuck in the transmissions queue?

    Are you using the Availability Group Listener IP in your Service Broker Route?

    Have you set the Service Broker route to use the Service Broker port (not 1433)?

    Have conversation end points been opened?

    Have you tried capturing extended event or profiler information (on initiator and target), capture all Service Broker events + broker related security/audit events to identify the point of dialog failure?

    Is the endpoint stopped or disabled?

    Sorry, there isn't enough information in your post to help much.

    Best wishes



    • Edited by Paul Brewer Tuesday, January 07, 2014 11:52 AM
    Tuesday, January 07, 2014 11:41 AM
  • Hi,

     I have the same message using Listener. Without listener the message not appears.

    Are you talking about Read-OnlyRouting when talks about Service Broker port?

    How know if endpoint is stopped or disable?

    Thank you

     

    Thursday, January 23, 2014 4:27 PM