Hi! I have a fresh install of SCE 2010 on a single server. When trying to view some types of reports (e.g. Update Deployment) I get: Date: 6/15/2010 1:29:13 PM 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'. Any ideas how to fix this? THanks, George

Hi George, Please try the methods in the following threads which are about the similar issue: WSUS Problem http://social.technet.microsoft.com/forums/en-US/systemcenter/thread/b7f34b6f-a105-41a1-8773-c9262afef455 SCE cannot connect to reports http://social.technet.microsoft.com/Forums/en-US/systemcenter/thread/d055d297-5c32-4f89-8b30-7fe15af08395 Hope this helps. Thanks. Nicholas Li - MSFT