by lunarg on May 22nd 2015, at 11:26

You can perform resource configuration for SQL Server Analysis Services (SSAS) through SQL Server Management Studio (SSMS). Simply connect to the SSAS (select Microsoft Analysis Server as server type and connect to the instance name). Using SSMS allows to change only a limited number of common and advanced parameters. Many of the very advanced parameters (usually those that require a restart of SSAS) can only be configured through a file called msmdsvr.ini.

The INI-file msmdsvr.ini, by default located in %PROGRAMFILES%\Microsoft SQL Server\<ssas-instance-name>\Config and in fact is an XML-file, allows you to configure both common and advanced parameters of SSAS. By default, the file is nearly empty, so in order to configure parameters, you need to add sections to the file yourself.

Changes made through SSMS are applied on the spot, but for changes in the msmdsvr.ini file to take effect, you need to restart SSAS.

Configure through SSMS

  1. Start SSMS and connect to the SSAS instance. Usually the instance name is the same as your SQL Server, unless you're running a dedicated SSAS server. For server type, select Microsoft Analysis Server.
  2. Right-click the server (tree on the left), then click Properties.
  3. In the window that appears, choose General on the left. The right pane will show a list of parameters, along with the default values and some other information. By default, only common parameters are visible. To view/change advanced parameters, tick Show Advanced (All) Properties.
  4. Make your changes, then click OK to apply them. Most (if not, all) changes made to these parameters are effective immediately.

Configure through msmdsvr.ini

    Locate the msmdsvr.ini file.
    By default, it's located at %PROGRAMFILES%\Microsoft SQL Server\<ssas-instance-name>\Config, but if unsure, you can always log on to SSAS by using SSMS, then checking the DataDir parameter for the exact location.
  1. Open msmdsvr.ini with a text editor (e.g. Notepad) and make your changes.
    A complete list of possible configuration values can be found on MSDN:
  2. After making changes to the file and saving it, you need to restart SSAS for these changes to take effect.