How to enable the SQL service broker

Owned by Agat Support
Last updated: Apr 14, 2022 by Avi J. Levin (Unlicensed)


When the Maintenance Service logs show the following error:


'ERROR AccessPortal.MaintenanceService.Services.TableListenerService - Could not set listener on table MESSAGES_OUTBOX'
In most cases this is caused from the SQL service broker not being enabled.
To enable the SQL service broker run the following SQL command


ALTER DATABASE [<AdminPortal>] SET ENABLE_BROKER with rollback immediate

Important

If the Admin Portal database is part of an Always-on Availability group, the database must be first removed from the Availability group so you can enable the Service Broker