SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Server 2012 SSAS .. 'Yes we can' use one instance for both the tabular and multi dimensional models

As most of us are aware, each instance of SSAS 2012 may be run in either tabular or multidimensional mode (and not both). This necessitates having 2 instances should you wish to do both.

HOWEVER, I picked up something interesting at the PASS Nordic Rally. There is an UNSUPPORTED 'toggle' that you can change in the MSMDSRV.INI File which will allow you to use the same instance in both modes, albeit one mode at a time. Doing so DOES necessitate either a stopping and restarting of the service and/or restarting the box. The person that put me onto it works for a major US consulting firm and does this all the time.

Here is the link to the necessary documentation from the books online.


regards Steve



Posted by drewskyjones on 1 November 2012

What would be the use case for "toggling" the deployment mode?

Leave a Comment

Please register or log in to leave a comment.