Article Number
000031535
Applies To
RSA Product Set: ECAT
RSA Product/Service Type: ECAT Server, MS SQL
RSA Version/Condition: 4.x
Issue
When trying to start ConsoleServer.exe, the following error is returned:Image description
Cause
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.
Resolution
Run the following query in MS SQL Server Management Studio:
ALTER DATABASE [TYPE_DB_NAME_HERE] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE e.g. ALTER DATABASE ECAT$PRIMARY SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE Image descriptionIn MS SQL 2012 you can do also Properties-> Options -> Service Broker
ALTER DATABASE [TYPE_DB_NAME_HERE] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATEe.g. ALTER DATABASE ECAT$PRIMARY SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE