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.