Web Analytics: Verifies that the SQL Server Service Broker is enabled for the Web Analytics staging databases (SharePoint Foundation 2010)
Applies to: SharePoint Foundation 2010
Rule Name: Web Analytics: Verifies that the SQL Server Service Broker is enabled for the Web Analytics staging databases
Summary: The service broker queue for the Web Analytics databases is not enabled. This causes Web Analytics data to not be processed.
Cause: This could be because of a recent SQL Server databases attach or detach or a backup or restore operation.
Resolution: Enable the service broker queue
- In Central Administration, on the Review problems and solutions page, click the rule, and then click Repair Automatically.