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. 😀
J Pratt