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
Richard Zirdung
Comments