Configuration Manager 2007 Reporting Point – Cannot set application role ‘webreport_approle’

Stumbled over an issue with a Configuration Manager 2007 Reporting point this morning. The customer couldn’t run a report, instead they got this message in the browser:

Cannot set application role ‘webreport_approle’ because it does not exist or the password is incorrect

For what-ever reason it turned out the application role has dropped the default permissions in SQL. To fix and verify the problem I:

  1. Started SQL Server Management Studio
  2. Navigated to SMS_SiteCode, Security, Roles, Application Roles,
  3. verified that the wbreport_approle is created

    image

  4. Opened the properties for the role and assigned the webreport_approle schema (which is the default setting for a normal working ConfigMgr. 2007 site).

    image

  5. Save the changes and reporting works like a charm again.
By | 2012-01-06T12:38:53+00:00 January 6th, 2012|Configuration Manager (SCCM)|1 Comment

About the Author:

Kent Agerlund
Microsoft Regional Director, Enterprise Mobility MVP. Microsoft Certified Trainer and Principal consultant. I have been working with Enterprise client management since 1992. Co-founder of System Center User Group Denmark in 2009. Certified MCITP: Enterprise Administrator, MCSA+Messaing, and much more. Member of: Microsoft Denmark System Center Partner Expert Team The Danish Technet Influencers program System Center Influencers Program.

One Comment

  1. I would like to thank you for the efforts you have put in penning this blog.
    I am hoping to see the same high-grade content by you in the future as well.

    In fact, your creative writing abilities
    has inspired me to get my own website now 😉

Leave A Comment