sql安装错误代码0×84B20001 的解决办法-无法安装SQLServer 2008 R2 64-bit

在安装 SP1 for SQL Server 2008 R2 64-bit 的时候遇到 0x84B20001这样的错误 怎么解决呢？

保删除所有sql服务器程序。使用控制面板进行验证。从程序文件中删除SQL Server目录。

要变通解决此错误，请按照下列

步骤操作：

步骤0

如果已安装Visual Studio 2008 SP1，则必须首先按照http：// support中的说明通过“添加/删除程序”删除“ Microsoft SQL Server Compact 3.5 SP1 <语言>”。 microsoft.com/default.aspx/kb/970876。（它将在修复过程中稍后重新安装；这可以解决SQL Server 2008安装程序中的另一个错误。）

步骤1.

下载并运行SQL Server 2008的原始自解压安装。如果有安装媒体，则可以使用“开始”菜单中的“ SQL Server安装中心”选项。

步骤2.

选择“维护>维修”。当被问及要修复什么时，选择“ <<仅修复共享组件>>”，然后完成修复。然后关闭SQL Server安装中心。

步骤3

.现在，您应该能够运行SP1安装程序。

祝好运！

TITLE: SQL Server Setup failure.
——————————

SQL Server Setup has encountered the following error:

A failure was detected for a previous installation, patch, or repair for instance ‘RETEST’ during configuration for features [SQL_Replication_Core_Inst,SQL_Engine_Core_Inst,MPT_AGENT_CORE_CNI,SQL_FullText_Adv,]. In order to apply this patch package (KB2528583), 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.
—————————————————-

All of the values for the registry keys located in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\ConfigurationState and HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\ConfigurationState are set to 1.

I tried doing a repair on the SQL Server installation, but but parts of the repair process failed. I have attached the log below. Thanks for your help!

—————————————————-SUMMARY.TXT—————————————————
Overall summary:
Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
Exit code (Decimal): -2068709375
Exit facility code: 1202
Exit error code: 1
Exit message: A failure was detected for a previous installation, patch, or repair for instance ‘RETEST’ during configuration for features [SQL_Replication_Core_Inst,SQL_Engine_Core_Inst,MPT_AGENT_CORE_CNI,SQL_FullText_Adv,]. In order to apply this patch package (KB2528583), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.
Start time: 2012-07-29 12:04:20
End time: 2012-07-29 12:04:52
Requested action: Patch
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120729_120413\Detail.txt
Exception help link: http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.50.2500.0%26EvtType%3d0xEDCCDB3F%400xF762992B%401202%401

Machine Properties:
Machine name: REFEDB
Machine processor count: 2
OS version: Windows Server 2008 R2
OS service pack:
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2008 R2 FETEST MSSQL10_50.FETEST Database Engine Services 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 FETEST MSSQL10_50.FETEST SQL Server Replication 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 FETEST MSSQL10_50.FETEST Full-Text Search 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 FETEST MSAS10_50.FETEST Analysis Services 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 FETEST MSRS10_50.FETEST Reporting Services 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 RETEST MSSQL10_50.RETEST Database Engine Services 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 RETEST MSSQL10_50.RETEST SQL Server Replication 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 RETEST MSSQL10_50.RETEST Full-Text Search 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 RETEST MSAS10_50.RETEST Analysis Services 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 RETEST MSRS10_50.RETEST Reporting Services 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 Management Tools – Basic 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 Management Tools – Complete 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 Client Tools Connectivity 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 Client Tools Backwards Compatibility 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 Client Tools SDK 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 Integration Services 1033 Standard Edition 10.50.1600.1 No

Package properties:
Description: SQL Server Database Services 2008 R2
ProductName: SQL2008
Type: RTM
Version: 10
SPLevel: 1
KBArticle: KB2528583
KBArticleHyperlink: http://support.microsoft.com/?kbid=2528583
PatchType: SP
AssociateHotfixBuild: 0
Platform: x64
PatchLevel: 10.51.2500.0
ProductVersion: 10.50.1600.1
GDRReservedRange: 10.0.1000.0:10.0.1099.0;10.0.3000.0:10.0.3099.0
PackageName: SQLServer2008-KB2528583-x64.exe
Installation location: g:\b5a8a3a0290f2e595b0871a0bdf1\x64\setup\

User Input Settings:
ACTION: Patch
ALLINSTANCES: True
CLUSTERPASSIVE: False
CONFIGURATIONFILE:
ENU: True
FARMACCOUNT: <empty>
FARMADMINPORT: 0
FARMPASSWORD: *****
HELP: False
INDICATEPROGRESS: False
INSTANCEID: <empty>
INSTANCENAME: <empty>
PASSPHRASE: *****
QUIET: True
QUIETSIMPLE: False
UIMODE: Normal
X86: False

Receiving error 0x84B20001 while installing