Home > Microsoft, System Center > SCE 2010 Reporting, Essentials Reports not working

SCE 2010 Reporting, Essentials Reports not working

November 18, 2010 Leave a comment Go to comments

Date: 18/11/2010 16:53:44
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’.

If you get this error when you try to access your essentials reports under Reporting there is a quick and easy way to fix it.

Solution:

  • Open your SQL Management Studio.
  • Then browse to SUSDB database and select it, right click and select properties.
  • Under properties select permissions. There should be only 3 entries, which are Domain\Username, NT Authority\Network Service and COMPUTERNAME\WSUS Administrators. You want Domain\Username user, so select that one.
  • Under Explicit tab scroll down until you see Select. Tick it under Grant and press OK. Now go and try to run your reports again.

-Eric

Advertisements
  1. bryhall
    June 11, 2011 at 1:19 pm

    This may be due to a newer update, but DOMAIN\USERNAME didn’t work for me. I had to grant ‘select’ permissions to SERVERNAME\WSUS ADMINISTRATORS, which worked. Your post was the only one that helped me get to where I needed to go.

    Thanks!

    • June 11, 2011 at 2:58 pm

      You might be right, thanks for the update.

  2. Bzzz
    October 25, 2011 at 8:14 pm

    Perfect! I was unable to find this solution in other places!! Many thanks and cheers from Brazil!!!

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: