SQL Server Analysis Services crashes when you have multiple roles and run a CREATE SESSION CUBE statement in SQL Server

Applies to: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise

Symptoms


Consider the following scenario:

  • You use Microsoft SQL Server 2012, 2014, or 2016 Analysis Services.
  • You belong to two database roles that both have dimension data security permissions to a cube.
  • You execute a CREATE SESSION CUBE statement.

In this scenario, SQL Server Analysis Services may crash.

Resolution


This problem was first fixed in the following cumulative update for SQL Server:



Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology Microsoft uses to describe software updates.