Share via

Authorization is not working for SSRS 2019 Custom security extension

Satya Kiran Unnamatla 1 Reputation point
2021-03-01T10:44:21.177+00:00

Please find environment details on which I am trying to implement Custom security sample.

SQL Server:- Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)
SQL Server Edition:-Microsoft Corporation Enterprise Edition
OS:- Windows Server 2019 Datacenter 10.0 (Build 17763: )
SSRS:- SQL Server Enterprise (15.0.1102.861)

Question 1 :-
I am able to Authenticate the user but Authorization is not working and user is unable to get any permissions either on Folder or Reports. The error is "Could not load folder contents You are not allowed to view this folder. Contact your administrator to obtain the necessary permissions."

Question 2 :-
I tried to search for IAuthenticationExtension2 Interface under the SSRS 2019 library " Microsoft.ReportingServices.Interfaces.dll" but that is not available. Even tried to install the library from Official and Unofficial version from nuget package manager but the interface is not present in those libraries as well. Can someone share the correct URL to download the library that has IAuthenticationExtension2 Interface.

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,878 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,571 Reputation points
    2021-03-02T06:40:35.42+00:00

    Hi @Satya Kiran Unnamatla ,

    Question 1

    Login to the SSRS Report Manager.
    Add the SSRS Report Manager URL to Local Intranet Zone in Internet Explorer.
    Manage SQL Server Reporting Service 2019 Permissions.
    For more information ,please refer to : https://spgeeks.devoworx.com/ssrs-2016-you-are-not-allowed-to-view-this-folder-contact-your-administrator-to-obtain-the-necessary-permissions/

    Question 2

    You could refer to: How to install custom security extensions.

    In order to better resolve the issue, we suggest one case for one issue. Thanks for understanding.
    Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.