SQL 2005 SP2安裝失敗
来源:互联网 发布:线性优化算法 编辑:程序博客网 时间:2024/05/25 12:22
最近跟SQL的Hotfix很有緣,話說為了因應KB956391會造成SSRS無法列印報表的問題,跟同事逐一為手上的SQL及SSRS主機上Patch。
不過,其中一台SQL升級時卻遇到SP2無法安裝的情況,依據提示,查看了C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Hotfix下的幾個Log檔案:
Summary.txt中出現:
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Hotfix/SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Installing performance counters. The error is: 當檔案已存在時,無法建立該檔案。(英文原文為Cannot create a file when that file already exists)
Hotfix.log中看到
10/31/2008 13:02:39.738 Registry: Opened registry key "Software/Policies/Microsoft/Windows/Installer"
10/31/2008 13:02:39.738 Registry: Cannot read registry key value "Debug"
10/31/2008 13:10:17.525 MSP Error: 29528 The setup has encountered an unexpected error while Installing performance counters. The error is: 當檔案已存在時,無法建立該檔案。
用13:10:17當索引去查SQL9_Hotfix_KB921896_sqlrun_sql.msp.log:
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Fri Oct 31 13:10:16 2008
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='183' GetLastError='183'>
PerfTime Stop: Do_sqlPerfmon2 : Fri Oct 31 13:10:16 2008
Gathering darwin properties for failure handling.
MSI (s) (04!D8) [13:10:17:478]: Transforming table Error.
MSI (s) (04!D8) [13:10:17:478]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (04!D8) [13:10:17:525]: Transforming table Error.
MSI (s) (04!D8) [13:10:17:525]: Transforming table Error.
MSI (s) (04!D8) [13:10:17:525]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (04!D8) [13:10:17:525]: Transforming table Error.
MSI (s) (04!D8) [13:10:17:525]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (04!D8) [13:10:17:525]: Transforming table Error.
MSI (s) (04!D8) [13:10:17:525]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 183
MSI (s) (04!D8) [13:10:17:541]: Transforming table Error.
MSI (s) (04!D8) [13:10:17:541]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (04!D8) [13:10:17:572]: Transforming table Error.
MSI (s) (04!D8) [13:10:17:588]: Transforming table Error.
MSI (s) (04!D8) [13:10:17:588]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (04!D8) [13:10:17:588]: Transforming table Error.
MSI (s) (04!D8) [13:10:17:588]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (04!D8) [13:10:17:588]: Transforming table Error.
MSI (s) (04!D8) [13:10:17:588]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (04!D8) [13:10:17:588]: Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: 當檔案已存在時,無法建立該檔案。
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: 當檔案已存在時,無法建立該檔案。
由這些線索看來,應與Performance Counter安裝失敗有關,但是哪一個Counter安裝失敗,並無進一步的訊息。我再去找了Event Log,看到了以下兩則訊息:
13:10:16 LoadPerf Error 3009
為 SQLSERVERAGENT 安裝效能計數器字串時失敗。 錯誤碼為記錄資料的 DWORD 0。
13:10:17 MsInstaller Error 10005
Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: 當檔案已存在時,無法建立該檔案。
看起來SQL Agent Performance Counter的嫌疑很大,於是我切到C:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/Binn,下了以下指令移除幾個可疑的Performance Counter:
lodctr /R:perf-MSSQLSERVERsqlagtctr.ini
(我還一併移除了sqlagtctr.ini, sqlctr.ini, perf-MSSQLSERVERsqlctr.ini,但以上的我覺得最可疑)
再試一次,SP2安裝成功! 運氣真好~~~
- SQL 2005 SP2安裝失敗
- SQL Server 2014 SP2
- SQL*Plus SP2错误信息
- Microsoft.SQL.Server.2005 (32位) SP2 简体中文企业版
- SQL Server 2005 安装不了SP2的原因及解决办法
- Windows 2003 Enterprise SP2成功安装SQL Server 2005 Enterprise
- Windows 2003 Enterprise SP2成功安装SQL Server 2005 Enterprise
- xp sp2装sql 2000
- sql*plus中SP2-0618和SP2-0611的解决方法
- SQL 2008 SP2 找不到SQL Server Engine
- sp2
- sp2
- Microsoft 数据库三版本共存:SQL Server 2000(SP4) + SQL Server 2005(SP2) + SQL Server 2008
- WinXP Professional SP2安装VS2005Professional(en)后Sql 2005 Express不能启动
- SQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explained
- 将 MS SQL Server 2005 SP2 整合到安装文件中
- SQL Server 2005 sp2安装后导入数据出错的处理方法
- 关于SQL Server 2005 SP2中提供的Vardecimal存储格式
- 国有资产流失的现状及对策
- 编辑词条两线制变送器
- 给定两个排好序的数组,怎样高效得判断这两个数组中存在相同的数字?
- 如何让页面居中显示
- 在VC中使用SQLite的例子(转)
- SQL 2005 SP2安裝失敗
- Check Access Rights to File/Directory on NTFS Volume
- Epicor推出基于SOA的新一代ERP
- 编写功能简化的bc遇到的小问题
- Java Persistence Api
- git 之五分钟教程
- UVa Problem Solution: 850 - Crypt Kicker II
- wpa_supplicant 和 802.11g WPA 认证的配置
- Linux系统下查看oracle SID的方法