Search code examples
sql-serverexcelsql-server-2012master-data-services

Installing MDS Excel Add-In Issue with Prerequisites

I am attempting to install the Master Data Services Plugin for Excel, but can't get the install to actually process due to it saying the prerequisites are not installed:

Prerequisites Message

I have made sure I have the right version (32 bit) to match my version of excel (2010), and have the full version of .net 4.5 installed. If I try to install the full version of .net 4.0, I am told that the newer (4.5) version already is installed.

Here are some links with similar issues, but no response: Microsoft Answers; Microsoft Connect;

Has anyone else faced this issue and got around it?

Solution

  • So, this looks to be a simple fix. The installer needs to be run as administrator, but in order to do that you have to run it through the command prompt as administrator. After doing this, it installed ok.

    I'm not sure why the installer didn't request elevated privileges, but I'm guessing it couldn't properly query the system to verify the necessary prerequisites were installed.

    Hopefully this helps someone else in the future!