RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.
2. You try to apply an update (like a service pack or a hotfix or a cumulative update) to this instance. In this scenario, you will notice that update procedure in step number 2, does not complete successfully. You will also find an error like the following in Summary.txt:
"A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_WRITER,SQL_Browser_Redist,]. In order to apply this patch package ..."
This has been fixed in SQL Server 2008 SP1. However, you will see this issue when you apply SP1 after an Edition Upgrade.
After an Edition Upgrade is made to a SQL Server 2008 Edition, it sets ConfigurationState of various Shared Features to a failed update state (3) in the following registry key:
When a patch is applied, it will check the above registry key and will return an error if any feature is in a failed state. Status: Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This issue has been fixed in Service Pack 1 for SQL Server 2008. However the service pack only addresses issues with future updates. If you apply the service pack after the edition has been upgraded, you will still run into this problem and you need to go through the procedure documented in the Resolution section to fix the issue.
To resolve this problem, use one of the following options.
Repair the upgraded instance of SQL Server 2008 by using the Add or Remove Programs feature in Control Panel before applying any updates to the instance. For more information on this, refer to the following topic in Books Online:
Before doing the edition upgrade, update the SQL Server setup support files (sqlsupport.msi) package on the system with the SQL Server 2008 Service Pack 1 package. To do this follow these steps:
Download the service pack package that matches your system architecture. For example, download the x64 package of SQL Server 2008 Service Pack 1 if your system is an x64-based system. To obtain SQL Server 2008 Service Pack 1, visit the following Microsoft Download Center Web site:
MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, RELIABILITY OR ACCURACY OF THE INFORMATION CONTAINED IN THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE (THE “MATERIALS”) FOR ANY PURPOSE. THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE.
TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.