question

AshifShaikh-9988 avatar image
0 Votes"
AshifShaikh-9988 asked AmeliaGu-msft answered

Error in SQL Server 2016 (AOAG) - The Service Broker endpoint is in disabled or stopped state

There are several articles which states that this is normal and there is no impact on the overall health of the DB. However I am in the process of moving\migrating our DB from on Premise to Cloud with the help of Always on Availability groups.

https://social.msdn.microsoft.com/Forums/en-US/bc5c8a4b-bc09-4478-8434-7d2e0d5c203f/the-service-broker-endpoint-is-in-disabled-or-stopped-state?forum=sqlgetstarted

I just wanted to know whether this could cause any issues as such during the failover from On-premise to Cloud? and what is the simplest way to stop these errors on the DB? as it comes up every 15 mins on the forwarder.


SQL Server:
Microsoft SQL Server 2016 (SP2-CU15-GDR) (KB4583461) - 13.0.5865.1 (X64)
Oct 31 2020 02:43:57
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: )

sql-server-generalazure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi AshifShaikh-9988,
I think you this will not cause issue when migration.
You can try to create a service broker endpoint to stop these errors, for example:

 CREATE ENDPOINT [Endpointname] 
     STATE = STARTED 
     AS TCP  (LISTENER_PORT = 4022, LISTENER_IP = ALL ) 
 FOR SERVICE_BROKER (AUTHENTICATION = WINDOWS);

Please refer to ERRORLOG flooded with "Service Broker endpoint" messages and AlwaysOn: The Service Broker endpoint is in disabled or stopped state which might help.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.