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.

Updates to Microsoft SQL server 2008 will fail after an edition upgrade


Source: Microsoft Support

↑ Back to the top


RAPID PUBLISHING

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.

↑ Back to the top


Symptom

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.

↑ Back to the top


Cause

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.

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.

↑ Back to the top


Resolution

To resolve this problem, use one of the following options.

Option 1

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:

Option 2

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:
 
  1. 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:
  2. Extract the service pack by running a command similar to the following:
     
    SQLServer2008SP1-KB968369-x64-ENU.exe /x:C:\SP1
  3. Run the following command to update the setup support files:
    C:\SP1\x64\setup\1033\sqlsupport.msi
Note The SP1 file and folder names will be different based on your system architecture.

↑ Back to the top


More Information



References:


·          Upgrading to SQL Server 2008

·          SQL Server Troubleshooting and Support

·          SQL Server 2008 Service Pack 1


955396 How to troubleshoot SQL Server 2008 Setup issues

·          SQL Server Troubleshooting and Support

·          SQL Server 2008 Service Pack 1

↑ Back to the top


DISCLAIMER

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.

↑ Back to the top


Keywords: kb, kbnomt, kbrapidpub, kbnoloc

↑ Back to the top

Article Info
Article ID : 970608
Revision : 7
Created on : 8/19/2020
Published on : 8/20/2020
Exists online : False
Views : 94