http://www.sqlservercentral.com/blogs/simon_says/2012/10/26/sql-server-2012-ssas-yes-we-can-use-one-instance-for-both-the-tabular-and-multi-dimensional-models/

Printed 2014/09/16 05:55AM

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

By Stefaans, 2012/10/26

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.

http://msdn.microsoft.com/en-us/library/gg471594.aspx

regards Steve

 


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.