SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to relocate the msmdsrv.ini file for OLAP


How to relocate the msmdsrv.ini file for OLAP

Author
Message
Larry Kruse
Larry Kruse
Mr or Mrs. 500
Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)

Group: General Forum Members
Points: 595 Visits: 760
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!
Query Shepherd
Query Shepherd
Mr or Mrs. 500
Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)

Group: General Forum Members
Points: 550 Visits: 454
- 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
Query Shepherd
Larry Kruse
Larry Kruse
Mr or Mrs. 500
Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)

Group: General Forum Members
Points: 595 Visits: 760
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
Query Shepherd
Query Shepherd
Mr or Mrs. 500
Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)

Group: General Forum Members
Points: 550 Visits: 454
Okay...a pingback would be nice...I know these problems...most of my work is done at night BigGrin!

Greetz
Query Shepherd
Cary Davis
Cary Davis
Valued Member
Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)

Group: General Forum Members
Points: 59 Visits: 319
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.
rizwankhalid214
rizwankhalid214
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 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
jpratt-797544
jpratt-797544
SSC Veteran
SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)

Group: General Forum Members
Points: 223 Visits: 79
rizwankhalid214 (10/18/2013)
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


Thank you, thank you, thank you!

I am working on an in-place upgrade from SQL Server 2012 Enterprise to SQL Server 2014 Enterprise, including an SSAS instance, and have been fighting with moving the files from the "11" folders to the "12" folders. I could not get the SSAS service to start after moving the files, and found the incorrect parameter in the Binary Path property of the service (under SQL Server Configuration Manager). I knew it must be in the registry somewhere because it was not in the msmdsrv.ini file.

Your post with the registry key saved me! I stopped the service, copied the \Config folder to the new location, made the change in the registry, and restarted the service successfully. I tested it by renaming the C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER to have a ".old" extension, which it let me do since there was no longer a lock on the path. :-D
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search