trioloop.blogg.se

To grant access so that the user can edit or build reports, you can give them additional permissions in SSRS, such as the Report Builder permission to the Home folder. From there, create a new role assignment so that you can grant access to the “Content Manager” role. Enter the group or user name (in the domain\username formet), select System Administrator, and click OK.Ĭlick Home, and then click Folder settings.To create a new role assignment, click Security, then New Role Assignment. Internet Explorer opens SQL Server Reporting Servies to your Report Manager URL.Ĭlick Site Settings, and create a new role assignment so that you can assign the desired Active Directory group to the “System Administrator” role in SSRS. You can open the Microsoft Reporting Services Configuration Manager to view the Report Manager URL.

In Internet Explorer, go to your Report Manager URL. Run Internet Explorer as Administrator.To grant report administrator access in SSRS (SQL Server Reporting Services): However, for your convenience, a couple procedures are below. For example, some information can be found at this link: Please consult Microsoft documentation for the most current instructions for security configuration and granting access in SSRS. You use the SSRS role-based security to assign Active Directory users and groups to SSRS roles for both the site and folders.Īnyone reading reports will also need to configure their Internet Explorer installation, as mentioned in Adding your report services web site to your Internet Explorer trusted sites. Before you provide reports to your users, you need to give them the appropriate access within the Microsoft SQL Server Reporting Services application.