Feb
23

SSRS 2008 Security Item Level and System Level Role Definitions

By Ben  //  SSRS  //  No Comments

In SSRS 2008 it appears you can no longer configure item-level role definitions and system-level role definitions like you used to be able to do in SSRS 2005 as shown in this screenshot from SSRS 2005.

SSRS 2005 Site Settings

This functionality to define roles still exists but you can no longer access it through the Report Manager website. To manage item-level and system-level role definitions you need to use SQL Server Management Studio and use it to connect to SSRS on your server. Once you do that you can create new system-level and item-level role definitions. Once those are created you can go back to report manager and utilize the defintions you created in SSMS.

SSMS SSRS Login

System-Level Role Defintions…

System-Level_Role_Defintions

Item-Level Role Definitions

Item-Level_Role_Definitions

Leave a comment

Knowledge Bomb