From yesterday onwards, I am stuck up with an error while trying to deploy cube.
"You cannot deploy the model because the localhost deployment server is not running in multidimensional mode. "
"You cannot deploy the model because the localhost deployment server is not running in multidimensional mode. "
I started googling to find a solution. And I found it. By default, when we are installing sql server Analysis services use tabular mode. Without reinstalling, if u want to change to multidimensional mode, follow this steps.
Change the deployment mode
- Go to the path "C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config" and copy the file "msmdsrv.ini" to desktop.
- Open the file "msmdsrv.ini" and change the value of DeploymentMode to 0.
0 - Multidimensional
1 - SharePoint
2 - Tabular - copy the "msmdsrv.ini" back to the location "C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config" . Replace the existing "msmdsrv.ini" file.
- Restart the SQL Server Analysis Services (MSSQLSERVER) from Administartive Tools-> Services.
Deploy again. Success.
To know more, click the link below to change from multidimensional to tabular mode.
Hat's off to you! Thanks so much. :)
ReplyDeletehi, i am unable to start the service again after changing the deployment mode value to 0. when i revert it to 2 it starts again.
ReplyDeletebro did you find a way to fix this? mine also only works on 2
DeleteI am not finding deployment mode in the config file
ReplyDeleteThank you so much. Greatly appreciated.
ReplyDeleteThank you so much...
ReplyDeleteThank you very much!! Your steps helped me.
ReplyDeleteThanks, it works like charm
ReplyDelete