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.