Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to relocate the msmdsrv.ini file for OLAP Expand / Collapse
Author
Message
Posted Thursday, February 21, 2013 7:16 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 8, 2014 9:18 AM
Points: 92, Visits: 664
We recently purchased a high-performance SAN and I'm in the process of migrating stuff off from the old SAN drives onto new ones.

Although I have moved the data OLAP onto one of the new SAN LUNs, I still have the Analysis Services configuration file located on an old drive, and I would like to move it.

If it matters, the SQL Server is clustered along with analysis services.

I'm hoping that this can be accomplished without needing to completely re-install it on both cluster nodes.

Any help or advice is greatly appreciated.

Thanks folks!
Post #1422572
Posted Friday, February 22, 2013 6:18 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:41 AM
Points: 118, Visits: 355
- Disconnect all users from the cube
- Open Analysis Manager
- Right-click on server name
- Open Properties and you will be able to see Data folder on General tab (typically c:\Program Files\Microsoft Analysis Services\Data)
- Copy all files and sub-folders of Data folder to new location (using Command Prompt or Windows Explorer)
- Go back to Analysis Manager and set path of Data folder to new location
- Restart Analysis Services
- Test new setup by querying OLAP databases/cubes
- If everything is OK, delete original Data folde


Greetz
SQL Pizza



sometimes you dont see the pizza for the toppings...
seek and ya shall find...
Post #1423018
Posted Friday, February 22, 2013 6:43 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 8, 2014 9:18 AM
Points: 92, Visits: 664
many thanks for the advice Pizza!!!

I will give that a try and ping back here to let you and others know the results. It usually takes me a week to gain approval for a maintenance window on the prod cluster...

Larry
Post #1423026
Posted Friday, February 22, 2013 6:47 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:41 AM
Points: 118, Visits: 355
Okay...a pingback would be nice...I know these problems...most of my work is done at night :D!

Greetz
SQL Pizza



sometimes you dont see the pizza for the toppings...
seek and ya shall find...
Post #1423030
Posted Tuesday, April 30, 2013 1:11 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 11, 2014 11:25 AM
Points: 17, Visits: 306
I'll shoot something back to you! I actually just moved files to a new volume. I've updated Analysis Server Properties and moved all the files, even updated the Dump Directory in SQL Server Configuration Manager.

Everything works great...until....I try to delete the old olap folder. The msmdsrv.ini file at the old location is still being used by AS when the program starts. If I stop the service and rename this file, AS will not start. So somewhere in the config AS is still holding onto the location of this file which it depends on for start up.

Just don't have any idea where to find it. Any clues?

I definitely can't see the pizza for the toppings here.
Post #1448209
Posted Friday, October 18, 2013 1:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 21, 2013 9:35 AM
Points: 1, Visits: 4
Hi,
please follow below steps

1-stop analysis Services on your New Server from SQL Server Configuration Manager and close SQL Server Configuration Manager
2-go to registry . START>RUN>regedit
3-in registry , go to
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MSSQLServerOLAPService. and Edit the Image path as per your new path.

Hope this will help you.

regards,
Rizwan
Post #1506004
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse