Error code 0x84B20001 when trying to install SQL Server 2008R2 SP1

转载自http://blog.sql-assistance.com/index.php/error-code-0x84b20001-when-trying

When trying to install SQL Server 2008R2 SP1 the following error can appear:

 

A Failure was detected for a previous installation, patch, or repair For instance ?MSSQLSERVER? during configuration for features [SQL_Engine_Core_Shared, SQL_POWERShell_Engine_CNS, CommonFiles, CommonFiles_Loc].In order to apply this patch package (KB2072493), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.

Error code 0x84B20001.

The solution suggested by some forums was to update some registry entries. In my situation the following registry keys needed modification:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState

• CommonFiles
• CommonFiles_Loc
• SQL_Engine_Core_Shared
• SQL_POWERShell_Engine_CNS

 ...

The REG_DWORD values were set to 3 and I had to change them to 1. This change solved my problem and the SQL Server 2008 R2 SP1 installed successfully. 

Depending on the feature list from your error message, search the corresponding registry keys and modify their REG_DWORD values from 3 to 1: