SCE 2010 SP1, SQL 2008 on Server 2008 R1 - SCE Reports are not running - "cannot initialize report"
Ho Folks, I have a strange problem on a very basic functionality on my SCE2010 SP1: When I try to show one of me basic Reports, for instance "Essentials Report" I get a error stating "Cannot initialize report" Additional Information: Note: The following information was gathered when the operation was attempted. The information may appear cryptic but provides context for the error. The application will continue to run. Microsoft.Reporting.WinForms.ReportServerException: An error has occurred during report processing. (rsProcessingAborted) ---> Microsoft.Reporting.WinForms.ReportServerException: Query execution failed for dataset 'ComputerList'. (rsErrorExecutingCommand) ---> Microsoft.Reporting.WinForms.ReportServerException: The SELECT permission was denied on the object 'vComputerTarget', 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 'ComputerList'. (rsErrorExecutingCommand) ---> Microsoft.Reporting.WinForms.ReportServerException: The SELECT permission was denied on the object 'vComputerTarget', database 'SUSDB', schema 'PUBLIC_VIEWS'. --- End of inner exception stack trace --- Microsoft.Reporting.WinForms.ReportServerException: The SELECT permission was denied on the object 'vComputerTarget', database 'SUSDB', schema 'PUBLIC_VIEWS'. What I have done so far: Reset the SCE serviceaccount password in Reporting Center Configuration ManagerChanged the Reporting Service Account from "Network Service" to the SCE serviceaccount Any help would greatly appreciated since my database knowledge is very limited. Mike
March 29th, 2012 1:46pm

Hi Mike, Are you using a SQL server 2008 R2 as a remote database? I would suggest the following article. Please check if the reporting server was installed properly: How to Install System Center Essentials 2010 Reporting on a Remote Database Server http://technet.microsoft.com/en-us/library/ff603577.aspx Besides, 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 Thanks. Yog Li TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2012 4:20am

Hi Yog, no, the database is not a remote database. It is local. I see the database in SQL Server Management Studio on SQL Server 10.0.5500. The SQL hosts OperationsManagerDWReportServer$ESSENTIALSReportServer$ESSENTIALSTempDBSUSDBSystemCenterEssentials Any idea? Mike
April 2nd, 2012 4:34pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics