Knowledgebase
Core Console will not start with a error indicating that the Service Broker is not enabled
Posted by Richard Z on 20 July 2012 08:34 AM
Symptom
 
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
 
Solution
 
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))
Helpful
Not helpful

Comments (0)