How to enable the SQL Server Broker

Last update:
Created :
Written by Thomas Speekenbrink

Overview:

The Synchronizer will not be able to start if the SQL Server Service Broker is not enabled on both the Catalog as the Customer Database.

If the Service Broker is enabled you will not experience any problems, however, if the service broker is not enabled the Synchronizer service cannot be started.

How to: 

To check if the service broker is enabled execute the following command on the SQL server through Microsoft SQL Server Manager:

 

SELECT is_broker_enabled FROM sys.databases WHERE name = '[CATALOG NAME]';

SELECT is_broker_enabled FROM sys.databases WHERE name = '[CUSTOMER DB NAME]';

 

Replace the [CATALOG NAME] and [CUSTOMER DB NAME] with the correct values you entered previously in the configurator.

If the result of both queries is ‘1’, the Service broker is running, otherwise it is not running and it has to be enabled.

 

Execute the following command in Microsoft SQL Server Manager to enable the Service broker:

ALTER DATABASE [DATABASE NAME] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE

Replace the [DATABASE NAME] with the correct name of either the Catalog or the Customer database. When checking both databases again with the ‘SELECT’-queries both results should return ‘1’.