Wednesday, January 4, 2012

SSAS 2008 R2 Config File Edits

If you need to change the location of the AS data directories the .ini file will allow you to control each of the files needed for the instance.

From Config File:

Get the location of Config File of Current Instance.

Open Services.msc, look for Analysis Services Instance, in Path to executable look for the path of Config Directory it will appear something like this:

("C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Config")

Stop Analysis Services from Configuration Manager or from SQL Management Studio

Open Config Directory take a backup of existing file – msmdsrv.ini

Using Notepad open Config file (msmdsrv.ini ) and make changes with below mentioned Parameter.

Current Location: C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data to New Location D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data

Copy Data Directory to New Location (Recommendation Don’t Move (Cut and Paste) instead Copy and Paste)

Start Analysis Services

Open Management Studio

Check All Databases are Present

Tuesday, January 3, 2012

SSAS Articles