Se connecter
 
AccueilLibrairieFormationTéléchargementsSupport techniqueCommunautésForums
Pour les professionnels de l’informatique >
> 
> 
SCE 2010 SP1, SQL 2008 on Server 2008 R1 - SCE Reports are not running - "cannot initialize report"

Traitée SCE 2010 SP1, SQL 2008 on Server 2008 R1 - SCE Reports are not running - "cannot initialize report"

  • jeudi 29 mars 2012 17:46
     
     
    Connectez-vous pour voter
    0

    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 Manager
    • Changed the Reporting Service Account from "Network Service" to the SCE serviceaccount

    Any help would greatly appreciated since my database knowledge is very limited.

    Mike

     

Toutes les réponses