The Additive Design of SSAS Role Security

SSAS security roles are additive – that is, a user gets permission to access data allowed in any role to which the user belongs, even if another role membership for the same user does not allow access to the same data. This can cause confusion in some circumstances, and has been incorrectly reckoned a defect…


Analysis Services - Errors when trying to add a User as a Server Admin

When trying to add a user as a Server Admin to Analysis Services, you may encounter one of the following errors: The following system error occurred:  The trust relationship between the primary domain and the trusted domain failed. (Microsoft.AnalysisServices) Or The following system error occurred:  No mapping between account names and security IDs was done….


AdomdConnectionException using PerformancePoint hitting Analysis Services

I was working with a customer who was encountering problems trying to use a PerformancePoint Dashboard against an Analysis Services Instance. The issue came down to the Claims to Windows Token Service (C2WTS) configuration.  This is used to take the Claims context and convert it to a Windows Token for use to backend servers. When…


SharePoint Adventures : “The connection either timed out or was lost” with RS DataSource to SSAS

A customer had encountered an issue with their SharePoint 2010 / Reporting Services 2012 deployment.  They had setup a Data Source for Reporting Services that was setup to connect to a stand alone Analysis Services instance.  When they clicked on “Test Connection” they saw the following:   Within the SharePoint ULS Log, we saw the…


BISM: value of the 'EffectiveUserName' XML for Analysis property is not valid

I’ve been working with Power View reports and one of the items I was setting up was using a BISM Data source connecting to an Analysis Services Instance in Tabular Mode.  When I went to spin up a new Power View Report against the BISM Connection, I got the following error: Within the details, we…


Analysis Services Thread Pool Changes in SQL Server 2012

As part of the SQL Server 2012 release several changes were made to Analysis Services that should alleviate some issues previously seen on large NUMA node machines. Separation of IO and Processing Jobs To better understand how the changes that were made work, it is helpful to have some background information about what types of…


Report Builder and Firewalls

We have had a few customer calls come in on this scenario that I thought this needed to be documented a bit. Scenario: In this scenario, the customer has a data source defined on the Report Server.  Some were using Named Instances, others were using a Default Instance for the Data Source. There are some…


Updated Errors may occur after configuring Analysis Services to use Kerberos authentication on Advanced Encryption Standard Aware Operating Systems

The Microsoft SQL Server Analysis Services support team has seen an increasing number of issues involving errors when attempting to execute queries against or deploy databases to instances of Analysis Services 2005 and Analysis Services 2008 that are configured for Kerberos authentication and running on Windows 2008 Server or Windows Vista. This note provides information…


Changes introduced in CU#7 may impact Analysis Services backup and sync operations

Cumulative Update #7 for SQL Server includes a fix for Analysis Services backups to correct a problem with truncation of metadata files as described in KB Article 950968.  The fix involves changes to the locking levels used for backups, thereby avoiding the truncation issue which could have been encountered previously.   Unfortunately, the increased locking levels…


Processing appears to stall or become sluggish on multi-processor machines running Analysis Services 2005

Over the past several months PSS has received several reports of processing for cubes in SQL Server 2005 Analysis Services hanging or becoming unbearably slow.  Most of the reports have involved high end 64-bit servers with 4 or more processors and 8GB or more RAM.  In many instances the processing can be “jump started” again…