SCE 2010 Reporting, Essentials Reports not working

Date: 18/11/2010 16:53:44
Application: System Center Essentials
Application Version: 7.0.2432.1
Severity: Error
Message: Cannot initialize report.

Microsoft.Reporting.WinForms.ReportServerException: An error has occurred during report processing.
(rsProcessingAborted) —> Microsoft.Reporting.WinForms.ReportServerException: Query execution failed for dataset ‘StatusList’.
(rsErrorExecutingCommand) —> Microsoft.Reporting.WinForms.ReportServerException: The SELECT permission was denied on the object ‘fnUpdateInstallationStateMap’, database ‘SUSDB’, schema ‘PUBLIC_VIEWS’.
— End of inner exception stack trace —
— End of inner exception stack trace —
at Microsoft.Reporting.WinForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WinForms.ServerReport.GetParameters()
at Microsoft.EnterpriseManagement.Mom.Internal.UI.Reporting.Parameters.ReportParameterBlock.Initialize(ServerReport serverReport)
at Microsoft.EnterpriseManagement.Mom.Internal.UI.Console.ReportForm.SetReportJob(Object sender, ConsoleJobEventArgs args)
Microsoft.Reporting.WinForms.ReportServerException: Query execution failed for dataset ‘StatusList’.
(rsErrorExecutingCommand) —> Microsoft.Reporting.WinForms.ReportServerException: The SELECT permission was denied on the object ‘fnUpdateInstallationStateMap’, database ‘SUSDB’, schema ‘PUBLIC_VIEWS’.
— End of inner exception stack trace —
Microsoft.Reporting.WinForms.ReportServerException: The SELECT permission was denied on the object ‘fnUpdateInstallationStateMap’, database ‘SUSDB’, schema ‘PUBLIC_VIEWS’.

If you get this error when you try to access your essentials reports under Reporting there is a quick and easy way to fix it.

Solution:

• Open your SQL Management Studio.
• Then browse to SUSDB database and select it, right click and select properties.
• Under properties select permissions. There should be only 3 entries, which are Domain\Username, NT Authority\Network Service and COMPUTERNAME\WSUS Administrators. You want Domain\Username user, so select that one.
• Under Explicit tab scroll down until you see Select. Tick it under Grant and press OK. Now go and try to run your reports again.

-Eric