Sql-server – Migrating reports from SSRS 2005 to SSRS 2014 and SSAS 2005 cube to SSAS 2014

In order for a specific role to have permissions over a cube data you have to specifically grant cube permissions to that role. That can be done using the Cube tab in the role properties page: in SSAS

-> Databases -> Your db -> Roles -> your specific role -> Cubes tab.

You can assign specific permissions for:

• Access - None, Read, or ReadWrite
• LocalCube/DrillthroughAccess - None, Drillthrough/Drillthrough and Local Cube
• Process

Same for dimensions and their data and specific cell data. You can find further info about cube permissions in the following articles:

• Permissions and Access Rights (Analysis Services - Multidimensional Data)
• Configuring permissions for SQL Server Analysis Services
• Security with Analysis Services - Overview

Normally in SSRS you would use the SSRS management interface (/ReportsManager IIRC) to set user roles/perms by folder. They are normally inherited by subfolders though you can override that. The role 'browser' is most appropriate for end users as it allows them to run / view reports but not much more. If you grant a user 'browser' access for folder but not B then they will not be able to access folder B unless it is either a sub-folder of A (by default granted the same perms as A) or unless B is a sub-folder of another folder the user has 'Browser' access to.

You probably should not be granting domain users any rights directly with-in SQL Server. The various accounts that SQL Server itself uses as well as administrative accounts should be configured with-in SQL Server. End user access to SSRS is controlled by SSRS based on rules entered into SSRS.