SQL Server 2012 – How To change a Analysis Service Instance Type
Posted by Diego em Março 27, 2013
1) You will “loose” all your databases. They can’t simple be migrated from one type to another so delete or detach them all
2) Stop the SSAS Service
3) Go to the SSAS config folder (In my case C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config)
4) Open the msmdsrv file and change the value of the DeploymentMode tag from 0 to 1
5) Restart your server
If you are wondering why it is DeploymentMode=2 for tabular and not 1, DeploymentMode=1 is for PowerPivot for SharePoint instances.