Errors installing MDS upgrade/Latest Version of MDS

Question

I'm getting a "The Client version is incompatible with the Database version.  Please ask your administrator to upgrade the Client components or the Database components or both." 

I'm running SQL Server 2008 R2 SP3

ProductName: Microsoft SQL Server 2008 R2 Master Data Services
ProductVersion: 10.50.0.1
ProductRegistrationKey: 0
SchemaVersion: 1.0.103.0
EnterDTM: 7/9/2011 18:45
LastChgDTM: 12/28/2011 12:29

I downloaded and attempted to install the update recommended in MDS MSDN Blogs.  But the upgrade stopped during the upgrade database message below:

Description:
  Stopped working

Problem signature:
  Problem Event Name: CLR20r3
  Problem Signature 01: mdsconfigtool.exe
  Problem Signature 02: 10.50.1720.0
  Problem Signature 03: 4c1345a4
  Problem Signature 04: MDSConfigTool
  Problem Signature 05: 10.0.0.0
  Problem Signature 06: 4c1345a4
  Problem Signature 07: 4cb
  Problem Signature 08: 17
  Problem Signature 09: System.ArgumentNullException
  OS Version: 6.1.7601.2.1.0.272.7
  Locale ID: 1033

What is the Latest version?  Where can I get it?

Thank you.

Greg

Answer 1

which blog are you refering?

http://blogs.msdn.com/b/mds/archive/2015/01/06/update-for-the-master-data-services-mds-excel-add-in.aspx

The MDS Excel addin Januray update is for SQL Server 2014 and it is backwards compatible to SQL Server 2012. For SQL Server 2008 R2, you need upgrade the SQL server at least to 2012.

Answer 2

The blog I found was at: http://sqlblog.com/blogs/mds_team/archive/2010/08/25/downloading-and-installing-sql-server-2008-r2-master-data-services-mds-cumulative-updates.aspx

I'm not too concerned with the Excel add-in

Answer 3

Ok.

The 2008 R2 SP3 (10.50.6000.34) is the latest one for 2008 R2.

No more Cumulative Updates for SP3.

I think you downgrade the MDS to 10.50.1720.0 which is 2008 R2 RTM CU2.

You can fix it by following this blog. Although it is for SP1 but the steps applied to SP3.

http://sqlblog.com/blogs/mds_team/archive/2011/08/16/how-to-install-master-data-services-mds-service-pack-1-for-sql-server-2008-r2.aspx