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.
Consider the following scenario:
1. You perform an edition upgrade
for your SQL Server 2008 instance.
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:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
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.
: 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:
- Extract the service pack by running a command similar to the following:
- Run the following command to update the setup support files:
Note The SP1 file and folder names will be different based on your system architecture.
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.