SSAS security permissions

Access to data from SSAS cubes requires certain permissions be granted so that the client (.net/sql server) can gain access to the cube and pull the data.

Before You Begin

Set up SSAS security permissions for Touchstone and Touchstone Re applications to enable some of the SSAS components incorporated into these applications. SSAS components include the ability to generate map clusters and to build spatial advanced table and charts.

As part of the installation process, make sure that the following steps are taken so that SSAS cube data can be pulled from the SQL Server linked server connection.

Procedure

  1. Connect to the SSAS server using SSMS.
  2. Right-click the SSAS server in the list.
  3. Select the Security page.
  4. Add NT SERVICE\MSSQLSERVER for default instances.
  5. Add the account NT SERVICE\MSSQL$SQL2012 to the SSAS security.
    Note:

    The naming convention for SSAS named instances is NT SERVICE\MSSQL$NAMEDINSTANCE.