SQL Server 2008 打SP1 补丁遇到的问题
今天在我机器上给SQL Server 2008 打上SP1补丁时，错误不断，郁闷死了。我的机器是XP Server Pack 3， SQL Server 2008 版本：SQL Server 2008 版本
Microsoft SQL Server 2008- 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft CorporationEnterprise Evaluation Edition on Windows NT 5.1(Build 2600: Service Pack 3)
安装过程中，首先出现下面错： 修补程序的安装程序未能更新以下实例: GSP。（注: GSP 是我机器上的数据库实例），打开安装日志，查看具体原因
代码
Overall summary:
Final result: 修补程序的安装程序未能更新以下实例:GSP。若要确定失败的原因，请查看日志文件。
Exit code (Decimal): -2068643839
Exit facility code: 1203
Exit error code: 1
Exit message: 修补程序的安装程序未能更新以下实例:GSP。若要确定失败的原因，请查看日志文件。
Start time: 2010-09-21 14:10:06
End time: 2010-09-21 14:29:44
Requested action: Patch
Instance GSP overall summary:
Final result: 修补程序的安装程序未能更新共享功能。若要确定失败的原因，请查看日志文件。
Exit code (Decimal): -2068643839
Exit facility code: 1203
Exit error code: 1
Exit message: 修补程序的安装程序未能更新共享功能。若要确定失败的原因，请查看日志文件。
Start time: 2010-09-21 14:12:46
End time: 2010-09-21 14:28:58
Requested action: Patch
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100921_141002\GSP\sql_bids_Cpu32_1.log
Exception help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.2531.0
通过Exception help link 后面的连接地址，终于明白了原因：
代码
Explanation
An attempt was made to install (or update) SQL Server Native Client on a computer where SQL Server Native Client is already installed, and where the existing installation was from an MSI file that was not named sqlncli.msi.
User Action
To resolve this error, uninstall the existing version of SQL Server Native Client. To prevent this error, do not install SQL Server Native Client from an MSI file that is not named sqlncli.msi.
于是卸载 SQL Server Native Client，重启电脑（不重启直接安装，会在安装过程停止），重新安装SP1 补丁，结果这回又给报了个下面的错误
查看日志文件：
日志文件
Overall summary:
Final result: 修补程序的安装程序未能更新共享功能。若要确定失败的原因，请查看日志文件。
Exit code (Decimal): -2068643839
Exit facility code: 1203
Exit error code: 1
Exit message: 修补程序的安装程序未能更新共享功能。若要确定失败的原因，请查看日志文件。
Start time: 2010-09-21 15:25:18
End time: 2010-09-21 15:28:57
Requested action: Patch
Machine Properties:
Machine name: 20091228-1016
Machine processor count: 2
OS version: Windows XP
OS service pack: Service Pack 3
OS region: 中华人民共和国
OS language: 中文(中华人民共和国)
OS architecture: x86
Process architecture: 32 位
OS clustered: 否
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2005 MSSQLSERVER MSSQL.1 数据库引擎服务 2052 Developer Edition 9.00.1399.06 否
Sql Server 2005 MSSQLSERVER MSSQL.1 SQL Server 复制 2052 Developer Edition 9.00.1399.06 否
Sql Server 2005 MSSQLSERVER MSSQL.1 全文搜索 2052 Developer Edition 9.00.1399.06 否
Sql Server 2005 MSSQLSERVER MSSQL.1 SharedTools 2052 Developer Edition 9.00.1399.06 否
Sql Server 2005 MSSQLSERVER MSSQL.2 Analysis Services 2052 Developer Edition 9.00.1399.06 否
Sql Server 2005 MSSQLSERVER MSSQL.3 Reporting Services 2052 Developer Edition 9.00.1399.06 否
Sql Server 2005 SQLEXPRESS MSSQL.4 数据库引擎服务 2052 Express Edition 9.2.3042 否
Sql Server 2005 SQLEXPRESS MSSQL.4 SQL Server 复制 2052 Express Edition 9.2.3042 否
Sql Server 2005 SQLEXPRESS MSSQL.4 SharedTools 2052 Express Edition 9.2.3042 否
Sql Server 2005 DTS 2052 Developer Edition 9.00.1399.06 否
Sql Server 2005 Tools 2052 Developer Edition 9.00.1399.06 否
Sql Server 2005 ToolsClient 2052 Developer Edition 9.00.1399.06 否
Sql Server 2005 ToolsClient\Connectivity 2052 Developer Edition 9.00.1399.06 否
Sql Server 2005 ToolsDocument 2052 Developer Edition 9.00.1399.06 否
Sql Server 2005 ToolsDocument\BOL 2052 Developer Edition 9.00.1399.06 否
Sql Server 2005 NS 2052 Developer Edition 9.00.1399.06 否
Sql Server 2008 GSP MSSQL10.GSP 数据库引擎服务 1033 Enterprise Evaluation Edition 10.1.2531.0 否
Sql Server 2008 GSP MSSQL10.GSP 数据库引擎服务 2052 Enterprise Evaluation Edition 10.1.2531.0 否
Sql Server 2008 GSP MSSQL10.GSP SQL Server 复制 1033 Enterprise Evaluation Edition 10.1.2531.0 否
Sql Server 2008 GSP MSSQL10.GSP SQL Server 复制 2052 Enterprise Evaluation Edition 10.1.2531.0 否
Sql Server 2008 GSP MSSQL10.GSP 全文搜索 1033 Enterprise Evaluation Edition 10.0.1600.22 否
Sql Server 2008 GSP MSAS10.GSP Analysis Services 1033 Enterprise Evaluation Edition 10.1.2531.0 否
Sql Server 2008 GSP MSAS10.GSP Analysis Services 2052 Enterprise Evaluation Edition 10.1.2531.0 否
Sql Server 2008 GSP MSRS10.GSP Reporting Services 1033 Enterprise Evaluation Edition 10.1.2531.0 否
Sql Server 2008 GSP MSRS10.GSP Reporting Services 2052 Enterprise Evaluation Edition 10.1.2531.0 否
Sql Server 2008 管理工具 - 基本 2052 Enterprise Evaluation Edition 10.1.2531.0 否
Sql Server 2008 管理工具 - 完整 2052 Enterprise Evaluation Edition 10.1.2531.0 否
Sql Server 2008 客户端工具连接 2052 Enterprise Evaluation Edition 10.1.2531.0 否
Sql Server 2008 客户端工具向后兼容性 2052 Enterprise Evaluation Edition 10.1.2531.0 否
Sql Server 2008 客户端工具 SDK 2052 Enterprise Evaluation Edition 10.1.2531.0 否
Sql Server 2008 Integration Services 2052 Enterprise Evaluation Edition 10.1.2531.0 否
Package properties:
Description: SQL Server Database Services 2008
SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}
ProductName: SQL2008
Type: RTM
Version: 10
SPLevel: 1
KBArticle: KB968369
KBArticleHyperlink: http://support.microsoft.com/?kbid=968369
PatchType: SP
AssociateHotfixBuild: 0
Platform: x86
PatchLevel: 10.1.2531.0
ProductVersion: 10.0.1600.22
GDRReservedRange: 10.0.1000.0:10.0.1099.0;10.0.3000.0:10.0.3099.0
PackageName: SQLServer2008-KB968369-x86.exe
Installation location: f:\0e7a24712f7a830e7b8d37b8ba2bd1\x86\setup\
用户输入设置:
ACTION: Patch
ALLINSTANCES: False
CLUSTERPASSIVE: False
CONFIGURATIONFILE:
HELP: False
INDICATEPROGRESS: False
INSTANCENAME:
QUIET: False
QUIETSIMPLE: False
X86: False
Rules with failures:
Global rules:
There are no scenario-specific rules.
Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100921_152507\SystemConfigurationCheck_Report.htm
这回没看到啥有用的提示信息，查看系统日志 ，发现出现 在安装SP1补丁的这段时间：Start time: 2010-09-21 15:25:18End time:2010-09-21 15:28:57 里有下面一个错误
我感觉去服务里面查看Distributed Transaction Coordinator服务是否被关闭，结果发现该服务找不到了，Distributed Transaction Coordinator这个服务明明是启动的，因为前两天配置SQL Server分布式事务时，都折腾过。在运行里面输入命令msdtc.exe -resetlog， 执行后，重新刷新服务还是看不到该服务，只好重启电脑，发现这个服务是启动的，而且依赖的两个服务Remote Procedure Call (RPC)和Security Accounts Manager都是启动的，窃喜以为重新安装一下SP1补丁就可以解决问题了，结果安装后上面的问题还是重现，网上也没找不到啥资料，只好重新安装，然后把下面的共享功能给去掉。
哎，折腾了几个小时还是没有解决问题，真够郁闷的了。
页:
[1]