Pre-install SCCM 2019 Failed prompt no installation microsoft sql server 2014 anaysis managerment object

Accepted answer

AllenLiu-MSFT 44,101 Reputation points Microsoft Vendor

2020-11-13T08:42:25.75+00:00

@Tony Mu
Thank you for posting in Microsoft Q&A forum.
Have you followed the prompt to download and install Microsoft SQL Server 2014 Analysis Management Objects(AMO).
And we need to restart the server after installing the AMO. Older editions of AMO required the server to be restarted after installation.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Tony Mu 241 Reputation points

2020-11-13T08:47:26.427+00:00

Yes,install package download link:https://www.microsoft.com/en-us/download/details.aspx?id=53164#:~:text=The%20Microsoft%20SQL%20Server%202014%20SP2%20Feature%20Pack,which%20provide%20additional%20value%20for%20Microsoft%20SQL%20Server.
But it didn't work

AllenLiu-MSFT 44,101 Reputation points Microsoft Vendor

2020-11-13T09:02:25.607+00:00

Have you restart the server? And someone install the x86 version instead of x64 version to make the issue solved.
And you may try to manually import the registry entries follow below post:
https://social.technet.microsoft.com/Forums/ie/en-US/08ff5e64-08ae-4ce2-a8e3-25b6d54d4055/microsoft-sql-server-2014-analysis-management-objects?forum=setup

Tony Mu 241 Reputation points

2020-11-13T09:11:16.477+00:00

I've tried this before but it didn't work

AllenLiu-MSFT 44,101 Reputation points Microsoft Vendor

2020-11-17T06:39:26.703+00:00

According to below article, the SCSM prerequisite checks are looking the guid for 2014 AMO RTM. 2014 AMO SP2 creates a different key. Upgrading from RTM to SP2 removes the RTM guid and adds the new one, causing the prerequisite checks to fail.
https://community.cireson.com/discussion/2198/2012r2-2016-dw-upgrade-issue-sql-server-2014-analysis-management-objects

You have installed the 2014 SP2 Feature Pack, so it could be the cause.
You may download Microsoft® SQL Server® 2014 Feature Pack here:
https://www.microsoft.com/en-us/download/details.aspx?id=42295

Tony Mu 241 Reputation points

2020-11-17T07:00:58.663+00:00

Thank you very much
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Pre-install SCCM 2019 Failed prompt no installation microsoft sql server 2014 anaysis managerment object

0 additional answers

Your answer