SSAS: All Possible Scenarios of Changing SSAS Data Folder

  • Article

Title - All Possible Scenarios of Changing SSAS Data Directories

Scenario 1:

Recreating a New Data Folder in New Drive / Same Drive

Creating a New Data Folder and changing the Data File Location in configuration files as shown below -

1. Connect to your Analysis Server in SSMS with a user that is a member of the server role but NOT the user that installed the software

2. Right-click on the server in Object Explorer. Select 'Properties...'

3. On the general tab, change the value of the DataDir property to a different folder (it doesn't matter what)

4. Click 'OK' on "Analysis Server properties" dialog. You will get a message telling you that the server needs to be restarted

5. Restart your Analysis Server in Services panel.

Caveat -

If you change the DataDir property of Analysis Server read more…………….LINK