Error: "Executing SQL Statement - Message: User does not have permission to perform this operatio (4338746)

Error received in the log file when running a stored procedure and gatherings are not updating the Exchange at a Glance website.

"Server Name: '<LOCALHOST>
'Error: EOleException Source:LPMFramework.LPMHost Message:Framework
error in TMailboxReviewDataObjectSourceDataObjectSource.ExecuteFramework error in C:\PROGRAM FILES\QUEST
SOFTWARE\MESSAGESTATS\MailboxReview.LPM.TMailboxReviewTaskProcessor.Task Processor.ProcessObject Framework error in C:\PROGRAM FILES\QUEST SOFTWARE\MESSAGESTATS\Database.LPM.TSQLv1LogDataStore.DataStore.StoreObject Error in Executing SQL Statement - Message: User does not have permission to perform this operation on table 'T_ServersAtAGlance';; SQLStatement = EXEC PR_CalculateAggregates;; Param List ="

The account running the gathering doesn't have rights to run the SQL Statement = EXEC PR_CalculateAggregates on the T_ServersAtAGlance table, which would cause the Exchange at a Glance not to update correctly.

The MessageStats Admin Group doesn't have the right to truncate tables in the database, which is what the PR_CalculateAggregates is doing.

Confirm the permissions on the T_ServersAtAGlance table, under Properties, to confirm that the MessageStats_Admin Role has, SELECT, INSERT, UPDATE, DELETE and check the PR_CalculateAggregates Store Procedure for MessageStats_Admin Role has, EXEC.

TSQLv1LogDataStore.DataStore.StoreObject Error in Executing SQL Statement - Message: User does not have permission to perform this operation on table 'T_ServersAtAGlance';; SQLStatement = EXEC PR_CalculateAggregates;; Param List =

Confirm that the MessageStats Admin Group in SQL Enterprise Manager, Security, Logins under the properties has Public, db_ddladmin and MessageStats_Admin Roles assigned.

In SQL Enterprise Manager, check the actual privileges on the T_ServersAtAGlance table. Right-click on the T_ServersAtAGlance table and select All Tasks | Manage Privileges. If it's not set, execute the stored procedure PR_SETPERMISSIONS via query analyzer:

EXEC PR_SETPERMISSIONS

Then execute the PR_CalculateAggregates stored procedure to update the Exchange at a Glance web page via query analyzer::

EXEC PR_CalculateAggregates

Solution applies to MessageStats v5x and v6x.