SSRS 2017: unable to grant domain group rights to reports

Prins, Andre 116 Reputation points
2021-02-26T08:42:45.453+00:00

as part of a System Center Operations Manager (SCOM) installation, we also installed SQL/SSRS 2017. Reporting is working fine - I can grant AD users access to view the reports directly via http://reportserver/reports. only when I try to grant an AD group rights, it fails with the message 'The user or group name 'NAME' is not recognized. I tried granting rights to all 3 types of security groups (Local Domain, Global, Universal) and all 3 types fail. the fact that I can add a DOMAIN\username AD-user means that SSRS can connect to AD, so I am puzzled why groups cannot be added ?!??!? ![72416-image.png][1] [1]: /api/attachments/72416-image.png?platform=QnA

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,436 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,850 questions
0 comments No comments
{count} votes

Accepted answer
  1. CyrAz 5,181 Reputation points
    2021-03-02T08:07:27.3+00:00

    The theory is that you can't directly add groups to ssrs permissions once the ssrs instance has been reconfigured by SCOM.
    You need to create a SCOM role, add the AD group to that role and then add the role's guid to ssrs permissions.
    Read more here : https://myitworld.azurewebsites.net/2017/01/09/manage-report-operator-user-role-scom-2016/

    However, there have been reports of ongoing issues with granting access to ssrs for quite a while now : https://myitworld.azurewebsites.net/2017/01/09/manage-report-operator-user-role-scom-2016/

    https://social.technet.microsoft.com/Forums/en-US/cf56abf4-cd72-48fe-9ceb-05cf05b98e81/ssrs-2017-scom-2019-cannot-browse-folders?forum=operationsmanagerreporting


0 additional answers

Sort by: Most helpful