Microsoft KB Archive/934749

= BUG: Error message when you try to install SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2 from the existing active node: &quot;The product instance  been patched with more recent updates&quot; =

Article ID: 934749

Article Last Modified on 10/31/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Service Pack 1
 * Microsoft SQL Server 2005 Service Pack 2

-



Bug #: 508841 (SQLBUDT)



SYMPTOMS
Consider the following scenario:
 * You apply a hotfix on a Microsoft SQL Server 2005 failover cluster.
 * The SQL Server 2005 failover cluster has SQL Server 2005 Service Pack 1 (SP1) installed, or the SQL Server 2005 failover cluster has SQL Server 2005 Service Pack 2 (SP2) installed.
 * You add a new node to the SQL Server 2005 failover cluster.
 * You try to install SQL Server 2005 SP1 or SQL Server 2005 SP2 from the existing active node.

In this scenario, you receive the following error message:

The product instance  been patched with more recent updates.



WORKAROUND
To work around this problem, follow these steps.

Note You perform the following operations on the primary node of the failover cluster instance.
 * 1) Remove the hotfix that you applied.

Important If you have applied more than one hotfix on the SQL Server 2005 service pack, you must remove all the hotfixes. You must remove the hotfixes one at a time. Remove the hotfix that has the highest build number first. Then, remove the hotfix that has the next highest build number. Continue in this manner until you have removed the hotfix that has the lowest build number.
 * 1) Install the service pack of SQL Server 2005 that you want.
 * 2) If the SQL Server client tools are not installed, install the SQL Server client tools on the new node.
 * 3) Reapply the hotfix that you removed in step 1.

Important If you removed more than one hotfix in step 1, only reapply the hotfix that has the highest build number.
 * 1) Restart the new node.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
For more information about how to add a new node to a SQL Server 2005 failover cluster, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/ms191545.aspx

Keywords: kbsql2005cluster kbtshoot kbexpertiseadvanced kbbug KB934749

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.