SQL Server 2008 打SP1 补丁遇到的问题

今天在我机器上给SQL Server 2008 打上SP1补丁时，错误不断，郁闷死了。我的机器是XP Server Pack 3， SQL Server 2008 版本：

Microsoft SQL Server 2008  - 10.0.2531.0 (Intel X86)   Mar 29 2009 10:27:29   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Evaluation Edition on Windows NT 5.1 <X86> (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:18  End 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补丁就可以解决问题了，结果安装后上面的问题还是重现，网上也没找不到啥资料，只好重新安装，然后把下面的共享功能给去掉。

 

 哎，折腾了几个小时还是没有解决问题，真够郁闷的了。