When attempting to connect to an OLAP server, an error is displayed.
Complete text of error message is:
"Cannot set StorageEngineMode property of database 'OlapServer' to 'Traditional' because Analysis Services is in Tabular mode."
Cause:
This error message is caused when the OLAP server is pointed at an SQL Sever 2012 Analysis Services instance that is installed to run in tabular mode.
Resolution
The OLAP Server needs to be redirected to an instance of Analysis Services (SSAS) set to run in multidimensional server mode.
To ensure the SSAS server mode:
-
Open SQL Server Managment Studio (SSMS)
-
Connect to the instance of Analysis Services (SSAS)
-
Right-click the Analysis Server and select Properties
-
Ensure the Server mode is set to Multidimensional
Comments