Exchange 2010 Reporting does not work in SCOM 2007 R2.

Few weeks backs i was doing a installation of SCOM 2007 R2 and then installed the agent to Exchange 2010 and started monitoring, but when i try to genarate a report it was not working. When i try to run the report i got this error.

"An error has occured during report processing.

Query execution failed for dataset 'ServerStatistics'.

For more information about this error navigate to the report server on the local server machine , or enable remote errors"

There was no clue even in the Event Viewer, after researching for about several hours i found the solution.

The reason is DataWarehouseReader account not having the correct permission for the relevant items in the DWDatabase.

As the remedy you can run the following query in the SQL Management Studio

USE [OperationsManagerDW]

GO

GRANT SELECT, EXECUTE ON SCHEMA :: Exchange2010 TO "domain\DWReaderaccont"

GO

Replace OperationsManagerDW with the DB name of yours if you have not changed the default db name while installing SCOM.

Cheerful Monitoring with SCOM :)