IT Infrastructure blog

May 18, 2010

SCCM 2007 reporting is not working

Filed under: SCCM 2007 — Akther @ 10:58 am
Tags: ,

When i try to generate report from SCCM 2007 server it’s throwing below error and i was not in a position to generate any report

Report Name: Compliance 1 – Overall Compliance
Category: Software Updates – A. Compliance
Comment: This report returns the overall compliance data for an Update List.
Parameters: Update List ID (Required) ScopeId_000330B9-1284-4982-89B8-D1B64A7561F2/AuthList_5E0CBA68-7C8F-4AE7-8849-18EBABAE5F44
Collection ID (Required) SMS000ES 

 Compliance 1 – Overall Compliance
An error occurred when the report was run. The details are as follows:
The specified schema name “webreport_approle” either does not exist or you do not have permission to use it.
Error Number: -2147217900
Source: Microsoft OLE DB Provider for SQL Server
Native Error: 2760


Surely some thing wrong with “webreport_approle” in SQL server 2005.

What i did i went to SCCM database in SQL server 2005–> security–>Roles–>Application roles –> Webreport_approle –> properties–>Select webreport approle check box.

There was no permission on webreport_approle. And some how i don’t have any idea how this permission was removed!!

After that all the reports started working.



  1. It worked like a charm!

    Thank you

    Comment by kostas Stoilas — January 28, 2011 @ 12:29 pm | Reply

  2. Same issue here after domain rename. Thanks for fix.

    Comment by Hyperlite — January 24, 2012 @ 11:02 pm | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

Blog at

%d bloggers like this: