SQL Cache Dependency error.

Casper Creedy

• July 24, 2017 13:53

I've just installed Front Office, and I'm getting the following error in the Admin Error Log;

An error occurred when trying to enable SqlCacheDependency. The application will continue to function as normal but performance may not be optimal. 
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.

 

0

• Official comment

  

  Casper Creedy

  • July 24, 2017 13:54

  This can be resolved by connecting to the SQL machine, and running the following script. 

  ALTER DATABASE [dbname] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE

  IIS will need a refresh afterwards, and this error should stop occurring.

   

Please sign in to leave a comment.