Note:  This is an old article, citing an issue with legacy systems or providers. Some troubleshooting tips may still be applicable to newer versions.  However, this article has not been tested with newer releases after 2016.

Symptoms

You will receive the error below if you point your Olap server at an Analysis Services instance that is installed to run in tabular mode.

Cannot set StorageEngineMode property of database 'OlapServer' to 'Traditional' because Analysis Services is in Tabular mode.

Cause

This is a bug that can only occur on SQL Server 2012

Resolution

Change the OLAP server name to a multidimensional analysis services database or install a new instance of analysis services in multidimensional mode.