This incredibly powerful tool is packed with features which enable you to manage security in ways not previously possible, and at speeds that will astound you
In Report Manager it is impossible to get an overall view of security. You can only see the security for each individual item.
To ensure the integrity of your SSRS security is compliant with internal and external procedures and regulation, you need to manually check the security of every item in the report database.
SQL Azure takes 10 seconds to open each individual item before checking/amending.
SSRS Security Manager automates this operation to transform hours of manual repetition into minutes- error and omission free.
SSRS Security Manager uses the Reporting Services SOAP API’s to query the Report Server enabling you to manage SSRS security over the Internet. You do not require access to the reporting services database, just login as you do with Report Manager.
The icon is yellow indicating the security of the folder is inherited but there is an item in the folder that has different security (not inherited). In the above example DataSource1 is highlighted red to indicate this items security is not inherited. It is recommended only to change security on folders not items in folders. See SSRS Security best practices for further information
The icon is red indicating the data source called DataSource1 is not inherited
The icon is red indicating the folder DataSources is not inherited.
The icon is green indicating the Report Project 1 folder is inherited.
Systems Roles cannot be changed in SQL Azure Reporting