Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

Error: Cannot set StorageEngineMode property of database 'OlapServer' to 'Traditional'


This information applies to SQL Server 2012 only
Overview

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:

  1. Open SQL Server Managment Studio (SSMS)
  2. Connect to the instance of Analysis Services (SSAS)
  3. Right-click the Analysis Server and select Properties
  4. Ensure the Server mode is set to Multidimensional

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments