Core Console will not start with a error indicating that the Service Broker is not enabled
Posted by Richard Z, Last modified by Adam Zilliax on 20 July 2012 08:34 AM
If a Database has been modified, restored, or moved, the service broker is disabled.  The following error may get logged in the event logs:
[DataStor] ERROR: Exception: Failed to start Service Broker. The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported.  Please enable the Service Broker for this database if you wish to use notifications.
Use will also receive 'No Core Server defined.  Would you like to connect to a Core Server?' message when opening the Core Console and the Faronics Core Server service will not start
Using SQL Management Studio Express 2008/R2,
  • Right click on the database after login (administrator or owner priviledges on the Faronics Databases)
  • and go to properties
  • Under Options>Service Broker, set 'Enable Broker' to true   Alternatively, run a query to the Database with the following command:  ALTER DATABASE [database name] SET ENABLE_BROKER
(3 vote(s))
Not helpful

Comments (0)