Start a conversation

Core Console will not start with a error indicating that the Service Broker is not enabled

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.
 
User 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 privileges 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
Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Richard Zirdung

  2. Posted

Comments