SSAS: All Possible Scenarios of Changing SSAS Data Folder
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