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