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.
0 Comments