I recently installed SQL Server Analysis Services (SSAS) and used the default settings during the installation. Unfortunately, this meant I installed it using a Deployment Mode of
Multidimensional instead of
I wanted to avoid uninstalling so I did some poking around and found there is a setting file which can be amended to change the Deployment Mode. The file is
msmdsrv.ini which is in
C:\Program Files\Microsoft SQL Server\MSAS15.GP\OLAP\Config if you have installed it into the default location:
Find the DeploymentMode node and change the number to
The available options for this setting are:
Once you’ve saved the changes, restart the SSAS service and it will be running in the deployment mode.