How to determine if the server is installed in vertipaq model ?

– Only applies to CTP3 Denali SQL Server

Object Explorer icons for each server mode

If you look into the Anaysis service object in Management Studio , We can identify the server mode by checking the server icons . The second one in the picture shows the tabular mode. This selection is making while on setup process . The below example shows the multidimensional mode


For changing servermode

A server can only be deployed in one mode, and from a supportability standpoint, that mode is fixed at the time you install the software. However, if you recently installed the server and have not deployed any databases, you can safely switch the server mode between Tabular and Multidimensional. To do this, you change the DeploymentMode property in msmdsrv.ini and then restart the server. Valid values are 0 for Multidimensional and 2 for Tabular. This is possible in the other way also. The path for msmdsrv.ini is C:\Program Files\Microsoft SQL Server\MSSQL.n\OLAP\Config

Once you change it , you may need to restart analysis service. After that you can see the icon changed.



Comment please...

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s