Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Security permissions that are associated with the existing roles may reset when you use the Analysis Services Deployment Wizard to deploy a SQL Server 2005 Analysis Services project
Article ID: 933836 - View products that this article applies to.
You use the Analysis Services Deployment Wizard to deploy a Microsoft SQL Server 2005 Analysis Services (SSAS) project. If you select the Retain roles and members option on the Specify Options for Partitions and Roles page, security permissions that are associated with the existing roles reset to none.
Additionally, all the cube security settings that are defined by the roles and all the dimension security settings that are defined by the roles are lost.
This issue occurs because security permissions secure objects, and these objects contain the security permissions. Security permissions are not contained by the security roles with which the security permissions are associated. You cannot use the Retain roles and members option to maintain the existing security settings.
To maintain security settings after you run the Analysis Services Deployment Wizard, use one of the following methods.
Method 1To deploy a master SSAS project to many destination servers, follow these steps.
Note This method assumes that each server differs only in the dimension data permission of the security role.
Method 2Use this method if the following conditions are true:
Method 3Use the SQL Server 2008 version of the Analysis Services Deployment Wizard to deploy a project to a SQL Server 2005 Analysis Services engine.
Note In SQL Server 2008 Analysis Services, security object permissions that are associated with a role are retained by the Analysis Services Deployment Wizard if the Retain roles and members setting is checked. This behavior has changed from earlier versions of SQL Server Analysis Services.
The Analysis Services Deployment Wizard uses the XML for Analysis (XMLA) protocol to deploy the metadata of an SSAS project to a destination server. The XMLA protocol handles the output files that are generated by the SSAS project.
The Analysis Services Deployment Wizard provides three options that maintain certain security settings on the destination server. The following table lists these options and the behavior that occurs when you select these options.
When you use Analysis Management Objects (AMO) to create roles or other objects, we recommend that you provide the ID of the role and the name of role if you do not create many roles. For example, provide the ID of the role and the name of the role when you want to create fewer than 100 roles.
Collapse this tableExpand this table