Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The Service Broker endpoint is in disabled or stopped state Expand / Collapse
Author
Message
Posted Monday, May 5, 2014 11:41 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:26 PM
Points: 342, Visits: 825
I have a SQL 2012 Enterprise edition HADR cluster with 2 nodes and my event log on the second node (current primary for the AG) is being filled with these messages

The Service Broker endpoint is in disabled or stopped state


I wasn't able to find too much on the issue. I did find this one open Microsoft connect bug report from back in April 2013 http://connect.microsoft.com/SQLServer/feedback/details/783219/alwayson-the-service-broker-endpoint-is-in-disabled-or-stopped-state

Anyone ever have this issue? Any ideas on what might be causing it?

Let me know what other details I can provide to help figure this out.

O/S: Windows 2012
SQL Server 2012 v11.0.3412
Currently 1 AG with 1 DB
Post #1567643
Posted Tuesday, August 5, 2014 9:55 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 11:47 AM
Points: 60, Visits: 566
I am seeing the same message in the errorlog.
SQL Server 2012 (11.0.3373). We are using AlwaysOn AG's and have configured and are using the AG Listener for read only traffic.
I do not seem to be experiencing any issues as a result of the message but it would be nice to identify the cause of the message.
Post #1599823
Posted Monday, September 15, 2014 6:45 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 2:12 AM
Points: 76, Visits: 177
I am also having the same issue.
The error message shows in the SQL Server logs, and appears once every 15 minutes.
I have a SQL 2012 SP2.
Post #1613654
Posted Tuesday, September 16, 2014 1:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 1:32 AM
Points: 158, Visits: 225
U can find here more about service broker in sql server check this: http://mattsql.wordpress.com/2012/06/07/service-broker-what-does-a-dba-need-to-know/
Post #1613963
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse