Windows Server 2003 Sp2 下无法安装SQL Server 2008 Management Studio Express问题
钉子 发表于 2010-5-22 1:42:51
问题描述：
==========
因为需要，在Windows Server 2003 Sp2 安装SQL Server 2008 Management Studio Express，但一直无法安装成功，安装日志信息如下：
Overall summary:
Final result: SQL Server 安装失败。若要继续操作，请调查失败原因，更正问题，卸载 SQL Server，然后重新运行 SQL Server 安装程序。
Exit code (Decimal): -2068643839
Exit facility code: 1203
Exit error code: 1
Exit message: SQL Server 安装失败。若要继续操作，请调查失败原因，更正问题，卸载 SQL Server，然后重新运行 SQL Server 安装程序。
Start time: 2010-05-22 00:56:32
End time: 2010-05-22 01:00:52
Requested action: Install
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100522_005534\Msxml6_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.1766.0
Machine Properties:
Machine name: WEB01
Machine processor count: 2
OS version: Windows Server 2003
OS service pack: Service Pack 2
OS region: *
OS language: 中文(*)
OS architecture: x86
Process architecture: 32 位
OS clustered: 否
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Package properties:
Description: SQL Server Database Services 2008
SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}
ProductName: SQL2008
Type: RTM
Version: 10
SPLevel: 0
Installation location: h:\a3ee51ff98a004b80e5bf0b7\x86\setup\
Installation edition: EXPRESS_ADVANCED
用户输入设置:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: False
AGTSVCACCOUNT: <空>
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config
ASDATADIR: Data
ASDOMAINGROUP: <空>
ASLOGDIR: Log
ASPROVIDERMSOLAP: 1
ASSVCACCOUNT: <空>
ASSVCPASSWORD: *****
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: <空>
ASTEMPDIR: Temp
BROWSERSVCSTARTUPTYPE: Disabled
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100522_005534\ConfigurationFile.ini
ENABLERANU: False
ERRORREPORTING: False
FEATURES: SSMS
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <空>
FTSVCACCOUNT: <空>
FTSVCPASSWORD: *****
HELP: False
INDICATEPROGRESS: False
INSTALLSHAREDDIR: F:\Program Files\Microsoft SQL Server\
INSTALLSHAREDWOWDIR: C:\Program Files\Microsoft SQL Server\
INSTALLSQLDATADIR: <空>
INSTANCEDIR: C:\Program Files\Microsoft SQL Server\
INSTANCEID: <空>
INSTANCENAME: <空>
ISSVCACCOUNT: NT AUTHORITY\NetworkService
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
MEDIASOURCE: h:\a3ee51ff98a004b80e5bf0b7\
NPENABLED: 0
PID: *****
QUIET: False
QUIETSIMPLE: False
RSINSTALLMODE: FilesOnlyMode
RSSVCACCOUNT: <空>
RSSVCPASSWORD: *****
RSSVCSTARTUPTYPE: Automatic
SAPWD: *****
SECURITYMODE: <空>
SQLBACKUPDIR: <空>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLSVCACCOUNT: <空>
SQLSVCPASSWORD: *****
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: <空>
SQLTEMPDBDIR: <空>
SQLTEMPDBLOGDIR: <空>
SQLUSERDBDIR: <空>
SQLUSERDBLOGDIR: <空>
SQMREPORTING: False
TCPENABLED: 0
X86: False
Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100522_005534\ConfigurationFile.ini
Detailed results:
Feature: 管理工具 - 基本
Status: 失败: 请查看日志了解详细信息
MSI status: 失败: 请查看下面的详细信息
MSI error code: 0x5EBE5729
MSI log file location: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100522_005534\Msxml6_Cpu32_1.log
MSI error description:
Configuration status: 已通过
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100522_005534\SystemConfigurationCheck_Report.htm
原因：
==========
SQL Server 2008用的 MSXML 是 6.1，所以 SQL Server 2008 的安装程序执行过程中，发现系统上有 更新MSXML 6 SP2的版本，就放弃继续安装，而非略过。
解决办法：
==========
经过多方查找和验证，最后是kb968749给了我帮助，也就是在安装和删除程序中删除----MSXML 6 SP2 ，等安装完居SQL 2008后再重打这个补丁。