![sql report builder 2014 sql report builder 2014](https://www.datasparc.com/wp-content/uploads/2015/04/sql-server-client-tools.png)
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.
![sql report builder 2014 sql report builder 2014](https://i.stack.imgur.com/dxNZE.png)
To grant report administrator access in SSRS (SQL Server Reporting Services):
![sql report builder 2014 sql report builder 2014](https://csharpcorner-mindcrackerinc.netdna-ssl.com/UploadFile/BlogImages/07192020005841AM/12.png)
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.