Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

You cannot obtain updates from Microsoft Update on a server that has SQL Server 2012 MDS installed


View products that this article applies to.

Symptoms

Depending on the SQL Server component that is installed, you may not obtain all Microsoft SQL Server updates from Microsoft Update (MU) on a server that is running Microsoft SQL Server 2012 or Microsoft SQL Server 2012 Service Pack 1 (SP1) and that has SQL Server Master Data Service (MDS) installed. This issue occurs in either of the following scenarios:
  • Scenario 1
    The SQL Server MDS component is installed in an instance of SQL Server 2012 or SQL Server 2012 SP1 that does not have a SQL Server engine component installed.
  • Scenario 2
    The SQL Server MDS component is added to an instance of SQL Server 2012 or SQL Server 2012 SP1 that has a SQL Server engine component installed, and the SQL Server engine already has the latest update that is offered by MU.

↑ Back to the top


Workaround

To work around this problem, manually download and then install the MDS-related SQL Server update from the Microsoft Download Center.

↑ Back to the top


Status

This problem has been fixed in Microsoft SQL Server 2012 Service Pack 2 (SP2).

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: kbsurveynew, kbtshoot, kbexpertisebeginner, kb

↑ Back to the top

Article Info
Article ID : 2969894
Revision : 1
Created on : 1/7/2017
Published on : 8/12/2014
Exists online : False
Views : 458