DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 970608 - Last Review: September 29, 2009 - Revision: 3.1

On This Page

Source: Microsoft Support

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.

Symptom

Consider the following scenario:

1.     You perform an edition upgrade (http://msdn.microsoft.com/en-us/library/cc707783.aspx)   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.

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 (http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19) . 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.

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:
How to: Repair a Failed SQL Server 2008 Installation (http://msdn.microsoft.com/en-us/library/cc646006.aspx)

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:
    http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19 (http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19)
  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.

More Information



References:

·          Upgrading to SQL Server 2008 (http://msdn.microsoft.com/en-us/library/bb677622.aspx)

·          SQL Server Troubleshooting and Support (http://msdn.microsoft.com/en-us/sqlserver/bb895923.aspx)

·          SQL Server 2008 Service Pack 1 (http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19)


955396 (http://support.microsoft.com/kb/955396) How to troubleshoot SQL Server 2008 Setup issues

·          SQL Server Troubleshooting and Support (http://msdn.microsoft.com/en-us/sqlserver/bb895923.aspx)

·          SQL Server 2008 Service Pack 1 (http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19)

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.

APPLIES TO
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
Keywords: 
kbrapidpub kbnomt KB970608
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support