After performing selection criteria and choosing 'Display' I get the following error. I have tried peforming a site reset and removing and re-installing the reporting point. I still get the same error. 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 I would be grateful for any ideas. Thanks DW

There's a KB article on this exact error. Did the fix listed there not help you? http://support.microsoft.com/kb/936118

I did all of the steps listed in the article. The only thing I noticed is that SQL server has been changed from Windows authentication to mixed. Would that have anything to do with this as Kerberos authentication would not be available?

It was something that the SQL DBA did. They wanted to use mixed authentication against the database for some development interfaces to the data. They created a SQL User and made an owner of the webreport_approle. They deleted the user and created a new one that was not the owner so they had to issue the following command. ALTER AUTHORIZATION ON SCHEMA::[ webreport_approle] TO [webreport_approle] Cheers, DW

Had the same issue and the link below really was a life saver. http://exchangeengine.wordpress.com/2010/05/18/sccm-2007-reporting-is-not-working/ Cheers, U.NUmair Nawaz