Permissions configuration for SQL Server profiling services

Brief introduction:

This article describes how to configure the security settings for the SSAS database and cube-related dimensions.

The security settings for configuring profiling services in Management Studio are basically the same relative to the data engine. But there are also limitations, such as the privilege Configuration for SSAS, which is done around the role, and secondly, the members of the role must be based on Windows or ad environments, and SQL Server users, such as SA, are unusable. Also, permissions cannot be granted directly to Windows or ad users or groups, and these users or groups must be added to the role. In addition, if UAC is in an open state, it is possible to run bids as administrator of the "Run as admin" to make the configuration effective.

Translation notes:

This article from Mssqltips, is I have seen the most complete article, has been trying to write about the SSAS security aspects, so decided to bring directly to the translation, the original address:

Http://www.mssqltips.com/sqlservertip/2776/configuring-permissions-for-sql-server-analysis-services/?utm_ source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20140421

In the process of translation, for the cell data part because there is no specific use, so this part is basically literal translation over. Interested friends can work together to discuss this part of the topic.

The dimension part feels like the way it is described in the text (at least I understand it), so this part is written directly by my own understanding, without literal translation.

The concept of DWA in this paper is the first time I have seen, Data warehouse administrator, Bi Brothers can finally have a similar to the DBA.

To configure administrator permissions when SQL Server is installed:

The first step in configuring SSAS security is when you install SQL Server. In the process of installing SQL Server, some DBAs or dwa are always accustomed to the next step. However, some of the configuration interfaces in this process will still affect the installation results. One of the steps is to configure an admin account for SSAS, which will not be as cumbersome to configure other users after the account is configured. The Administrator account for SSAS will have full permissions, including all SSAS databases, cubes, dimensions, and so on.