Receive the following error during a gathering: "Unable to Validate the database connection, please restart Messagestats".
This error can occur when the MessageStats Service Account has been removed from the SYS Admin role on the SQL Server.
In order to connect to the MessageStats database using an account with Database Operator role (and not SYS Admin) do the following:
1. Grant the account DBO rights on the Messagestats database.
2. Grant data reader rights and execute permissions on the basic stored procedures within the MessageStats database.
3. Run SQL Profiler to check if analysis and gathering data from MessageStats database is successful. If there is a problem, check the Stored Procedure that needs to be given permissions and provide the data reader and execute permissions to it.
