Securing Analysis Services access to SQL Server

SQL Server Analysis Services (SSAS) can use its own data storage to keep multidimensional data, also known as MOLAP (Multidimensional OLAP). In MOLAP storage, SSAS connects to a data source to generate the cube content. When it is done, SSAS is self-sufficient and does not need to connect to any other data source to respond to clients' requests. However, when Relational OLAP (ROLAP) partitions are used, and when cubes or partitions are processed against a relational database, SSAS itself must act like a client and open a connection to SQL Server.


ROLAP stands for Relational OLAP. A ROLAP partition or cube does not store data in the cube. When a user queries a ROLAP structure, SSAS translates ...

Get Microsoft SQL Server 2012 Security Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.