Karan Gulati (SSAS Maestro)

BI Quick Questions:

——>

SSAS Configuration File

1)       What is the name of SSAS configuration file?

Answer: Msmdsrv.ini and its default location is (?:\Program Files\Microsoft SQL Server\MSAS??.Instance_Name\OLAP\Config)

2)      How to find path of configuration file, if SSAS is not installed using default paths?

Answer: Steps as follow:-

a)      Go to Services Console (Services.msc)

b)      Find SSAS Service

c)       Right click SSAS Service and go to its properties

d)       In General  section look for Path to executable

e)      Below Path to executable you will find complete path which looks something like this for default configuration –

“C:\Program Files\Microsoft SQL Server\MSAS11.TABULAR\OLAP\bin\msmdsrv.exe” -s “C:\Program Files\Microsoft SQL Server\MSAS11.TABULAR\OLAP\Config”

f)        Second part of the Path got location of Config directory where you will find msmdsrv.ini file

3)      How to rebuild SSAS msmdsrv.ini (Configuration) file?

Answer: Steps as follow:-

Steps as follow:-

a) STOP SQL Analysis Services

b) Go to SSAS Config folder (Default Path – ?:\Program Files\Microsoft SQL Server\MSAS??.Instance_Name\OLAP\Config)

c) In config folder you will find two files msmdsrv.ini and msmdsrv.bak, move these two files in any temporary folder

d) Start SSAS

e) After starting SSAS service you will find copy of newly created msmdsrv.ini and msmdsrv.bak files in config folder

f) File is created with default settings for all properties

e) To start with you can provide right path of Data, Teamp, Log and Backup Directory, otherwise root directly will be used for these folders. In a newly created msmdsrv.ini file, path looks something like this – <DataDir>\data</DataDir> which means use root directory for creating Data Folder

<——