Ensure the account being used to open the Report Manager is a member of at least the Reporter_Reporting_Admins group. If it is a member of this group and the error still occurrs, ensure the groups are members of the appropriate database roles:
- The Reporter_Discovery_Admins group needs to be a member of the Discovery_Admin_Role database role
- The Reporter_Discovery_Nodes group needs to be a member of the Discovery_Nodes_Role database role
- The Reporter_Reporting_Admins group needs to be a member of the Reporting_Admin_Role database role
- The Reporter_Reporting_Operators group needs to be a member of the Reporting_Operator_Role database role
If the groups are associated with the correct database roles, try adding a windows account directly to the Reporting_Admin_Role database role. If you can login after adding the account directly to the database role, try the following:
- Backup the ER DB
- On the SQL server, delete the DOMAIN\ Reporter_Discovery_Admins, DOMAIN\Reporter_Discovery_Nodes, DOMAIN\Reporter_Reporting_Admins, DOMAIN\Reporter_Reporting_Operators logins from the Security | Logins folder
- Create a new login for each Group, mapping the groups as follows:
DOMAIN\Reporter_Discovery_Admins - Mapped to the Discovery_Admin_Role on the ER DB
DOMAIN\ Reporter_Discovery_Nodes - Mapped to the Discovery_Nodes_Role on the ER DB
DOMAIN\Reporter_Reporting_Admins - Mapped to the Reporting_Admin_Role on the ER DB
DOMAIN\Reporter_Reporting_Operators - Mapped to the Reporting_Operator_Role on the ER DB - Once the SQL logins for the ER groups has been recreated and mapped to the corresponding DB role, please try logging into the Report Manager with an account that is a member of the DOMAIN\Reporter_Reporting_Admins group.
