Error: Permission denied on object 'T_LogJopurnal', database 'MessageStats'
The following error is reported when trying to run a gathering
"Messagestatsservice.exe Error: EOleException Source:Microsoft OLE Provider for SQL Server Message:UPDATE permission denied on object T_LogJopurnal, database MessageStats, owner dbo
The error indicates that the MessageStats Service account does not have rights to the MessageStats Database.
The rights required to run a successful gathering is:
1. MessageStats Service Account (automated) be added to the MessageStats Admin Security Group on the SQL Server 2. Then this group added to SQL Logins with the MessageStats_Admin, Public and db_ddladmin Roles applied. 3. This account will also require Exchange Admin and Local Admin rights to all Servers being gathered from.