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.