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: Started SQL Server Management Studio Navigated to SMS_SiteCode, Security, Roles, Application Roles, verified that the wbreport_approle is created Opened the properties for the role and assigned the webreport_approle schema (which is the default setting for [...]