The following error is logged while running a Default Gathering: "The following error occurred while processing a data object for a given gathering: Error in Executing SQL Statement - Message: User does not have permission to perform this action;; SQL Statement = EXEC PR_UpdateStatistics"
In addition, the Reporting Aggregation task fails with the following error: "The stored procedure PR_UpdateStatistics failed to refresh database statistics: Error in Executing SQL Statement - Message: User does not have permission to perform this action;; SQL Statement = EXEC PR_UpdateStatistics"
This issue occurs when the Owner of the MessageStats database does not match the identity of DBO in the MessageStats database
1. Then Right click on the MessageStats Database and select properties.
2. Select the Files link on the top left hand side and change the owner to "sa" and click OK
3. The Right click on the MessageStats Database again and select propeties select the files link again and re add the account to the Owner field that you removed in Step 1.
