When trying to start ConsoleServer.exe, the following error is returned:
The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. This issue may be noticed after a product upgrade.
Run the following query in MS SQL Server Management Studio:
ALTER DATABASE [TYPE_DB_NAME_HERE]SET ENABLE_BROKERWITH ROLLBACK IMMEDIATE e.g. ALTER DATABASE ECAT$PRIMARY SET ENABLE_BROKERWITH ROLLBACK IMMEDIATE
In MS SQL 2012 you can do also Properties-> Options -> Service Broker ALTER DATABASE [TYPE_DB_NAME_HERE] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE e.g. ALTER DATABASE ECAT$PRIMARY SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE