Sign in
 
Home2012Previous VersionsLibraryForumsGallery
System Center TechCenter >
> 
> 
System Center Essentials 2010 Reports not working correctly Installation type - Reporting/database on remote SQL server

Answered System Center Essentials 2010 Reports not working correctly Installation type - Reporting/database on remote SQL server

  • Friday, June 08, 2012 11:26 PM
     
     
    Sign In to Vote
    0

    I have the SCE installed on one server with the database & reporting services on a separate SQL server. I followed the documentation here:

    http://technet.microsoft.com/en-us/library/ff603577 (How to Install System Center Essentials 2010 Reporting on a Remote Database Server)

    When I run a hardware report or software report I received the below error. Other reports seem to work ok.

    Date: 6/8/2012 4:08:55 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 'ComputerList'. (rsErrorExecutingCommand) ---> Microsoft.Reporting.WinForms.ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors
       --- 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: For more information about this error navigate to the report server on the local server machine, or enable remote errors
       --- End of inner exception stack trace ---
    Microsoft.Reporting.WinForms.ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors

     

All Replies

  • Saturday, June 09, 2012 12:09 AM
     
     
    Sign In to Vote
    0

    Wanted to provide a bit more detail. It seems none of the reports in "Reporting" - "Essentials Reports" work, but other reports work like the Host Utilization report under Reporting - System Center Virtualization Reports 2008 R2.

     
  • Monday, June 11, 2012 10:01 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hello,

    "Cannot initialize report" occurs may because your System Center “Run As” account does not have SQL select permission on the SUSDB database.

    To fix this you can try to give this account the proper permission by following these steps:

    • Logon to your SCE server or SQL server that hosts your “SCE” instance.\
    • Open SQL Management studio>>>open the SCE instance>>>locate the SUSDB database.
    • Right click on the SUSDB database and chose properties.
    • Click on Permissions on the left hand side. You should see your “Run As” account listed here.
    • Highlight the “Run As” account and scroll down in the Permissions for “DOMAIN\USER” until you see “Select”. Check the box under Grant and then click ok.

    NOTE:Your “Run As” account should also have Grant permission for Connect as well. If this is not checked please check it.

    Now go back to System Center Essentials and try to run any of the Essentials Reports to see if it works.

    Thanks,

    Yog Li

    TechNet Community Support

    • Marked As Answer by paynster02 Monday, June 11, 2012 12:11 PM
    •  
     
  • Monday, June 11, 2012 12:11 PM
     
     
    Sign In to Vote
    0
    That did it, Thank you!