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

来源：互联网发布：淘宝手机一屏尺寸多少编辑：程序博客网时间：2024/05/20 14:23

转载自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:

0 0