none
安装sqlserver 2005 sp3,其中sqlserver数据库部分升级总是失败 RRS feed

  • 问题

  • 是给一个安装在windows 2003 企业版上的sqlserver 2005 打sp3积累更新补丁(SQLServer2005SP3-KB955706-x86-CHS.exe)

    安装补丁过程中除了sqlserver本生补丁安装失败外,其它组件都能正常安装补丁

    下面是日志中的出错信息

    ##############################################################
    HotFix.log

    02/03/2010 11:13:12.156 Registry: Set registry key value "CustomerFeedBack", DWORD value = 0
    02/03/2010 11:13:12.203 Locked file: Checking for locked files
    02/03/2010 11:13:12.687 Locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\msfte.dll (MSSQLSERVER [sqlservr.exe] - 3784)
    02/03/2010 11:13:14.687 Attempting to pause the 32 bit ngen queue
    02/03/2010 11:13:15.609 Installing product: SQL9
    02/03/2010 11:13:15.609 Installing instance: MSSQLSERVER
    02/03/2010 11:13:15.609 Installing target: NNS9J1TDF3O
    02/03/2010 11:13:15.625 Stopping service: MSSQLServer
    02/03/2010 11:13:17.625 Stopped service: MSSQLServer
    02/03/2010 11:13:17.625 Installing file: sqlrun_sql.msp
    02/03/2010 11:13:17.828 Copy Engine: Creating MSP install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
    02/03/2010 11:13:17.828 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
    02/03/2010 11:13:17.828 Registry: Cannot read registry key value "Debug", error 0
    02/03/2010 11:13:27.109 MSP Error: 29528  安装程序在 正在设置内部属性 期间遇到错误。错误为: 安装时发生严重错误

    02/03/2010 11:13:27.500 MSP returned 1603: 安装过程中出现严重错误。
    02/03/2010 11:13:27.531 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
    02/03/2010 11:13:27.531 Registry: Cannot read registry key value "Debug", error 997
    02/03/2010 11:13:27.718 Copy Engine: Error, unable to install MSP file: e:\c3ff605247fbaf234d9b1ca1\HotFixSQL\Files\sqlrun_sql.msp
    02/03/2010 11:13:27.718 The following exception occurred: 无法安装 Windows Installer MSP 文件  Date: 02/03/2010 11:13:27.718  File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp  Line: 807
    02/03/2010 11:13:28.125 Watson: Param1 = SetInstanceProperty
    02/03/2010 11:13:28.125 Watson: Param2 = 0x7358
    02/03/2010 11:13:28.125 Watson: Param3 = SetInstanceProperty
    02/03/2010 11:13:28.140 Watson: Param4 = 0x7358
    02/03/2010 11:13:28.140 Watson: Param5 = sqlca\sqlcax.cpp@1224
    02/03/2010 11:13:28.140 Watson: Param6 = Unknown
    02/03/2010 11:13:28.140 Watson: Param7 = SQL9
    02/03/2010 11:13:28.140 Watson: Param8 = Hotfix@
    02/03/2010 11:13:28.140 Watson: Param9 = x86
    02/03/2010 11:13:28.140 Watson: Param10 = 4035
    02/03/2010 11:13:28.140 Installed product: SQL9
    02/03/2010 11:13:28.140 Hotfix package completed
    02/03/2010 11:13:28.140 Attempting to continue the 32 bit ngen queue
    #############################################################

    Summary.txt

    Product                   : 数据库服务 (MSSQLSERVER)
    Product Version (Previous): 3042
    Product Version (Final)   :
    Status                    : 失败
    Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
    Error Number              : 29528
    Error Description         : MSP Error: 29528  安装程序在 正在设置内部属性 期间遇到错误。错误为: 安装时发生严重错误

    ############################################################################################


    SQL9_Hotfix_KB955706_sqlrun_sql.msp.log

    Property(S): PackageCode = {43C020BF-8F7D-4117-BE12-FE45822C0915}
    Property(S): SQL200532Hotfix4035 = e:\c3ff605247fbaf234d9b1ca1\HotFixSQL\Files\sqlrun_sql.msp
    MSI (s) (8C:64) [11:13:27:421]: 产品: Microsoft SQL Server 2005 - 无法安装更新 'SQL Server Database Services 2005 Service Pack 3 CHS (KB955706)'。错误码 1603。可以在日志文件 C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log 中找到其他信息。

    MSI (s) (8C:64) [11:13:27:421]: Note: 1: 1729
    MSI (s) (8C:64) [11:13:27:421]: Transforming table Error.

    MSI (s) (8C:64) [11:13:27:421]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (8C:64) [11:13:27:437]: Transforming table Error.

    MSI (s) (8C:64) [11:13:27:453]: Transforming table Error.

    MSI (s) (8C:64) [11:13:27:453]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (8C:64) [11:13:27:453]: Transforming table Error.

    MSI (s) (8C:64) [11:13:27:453]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (8C:64) [11:13:27:453]: Transforming table Error.

    MSI (s) (8C:64) [11:13:27:453]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (8C:64) [11:13:27:453]: Transforming table Error.

    MSI (s) (8C:64) [11:13:27:453]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (8C:64) [11:13:27:468]: Transforming table Error.

    MSI (s) (8C:64) [11:13:27:468]: Transforming table Error.

    MSI (s) (8C:64) [11:13:27:468]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (8C:64) [11:13:27:468]: Transforming table Error.

    MSI (s) (8C:64) [11:13:27:468]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (8C:64) [11:13:27:468]: Transforming table Error.

    MSI (s) (8C:64) [11:13:27:468]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (8C:64) [11:13:27:468]: 产品: Microsoft SQL Server 2005 -- 配置失败。

    MSI (s) (8C:64) [11:13:27:468]: Attempting to delete file C:\WINDOWS\Installer\20bb16.msp
    MSI (s) (8C:64) [11:13:27:468]: Unable to delete the file. LastError = 32
    MSI (s) (8C:64) [11:13:27:500]: Cleaning up uninstalled install packages, if any exist
    MSI (s) (8C:64) [11:13:27:500]: MainEngineThread is returning 1603
    MSI (s) (8C:54) [11:13:27:500]: Destroying RemoteAPI object.
    MSI (s) (8C:38) [11:13:27:500]: Custom Action Manager thread ending.

    2010年2月3日 4:09

答案

  • Summary.txt

    Product                   : 数据库服务 (MSSQLSERVER)
    Product Version (Previous): 3042
    Product Version (Final)   :
    Status                    : 失败
    Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
    Error Number              : 29528
    Error Description         : MSP Error: 29528  安装程序在 正在设置内部属性 期间遇到错误。错误为: 安装时发生严重错误


    Try refer this article,
    http://support.microsoft.com/kb/925976



    2010年2月9日 4:09
    版主

全部回复

  • Looks like the windows account you used doesn't have proper registry permission.
    2010年2月3日 4:30
  • 用的是administrator怎么会没权限?

    能说具体点如何添加这个权限?

    ls说的是这段是吧:02/03/2010 11:13:17.828 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
    02/03/2010 11:13:17.828 Registry: Cannot read registry key value "Debug", error 0


    查了下注册表这个无法读取不是权限不够造成的,是根本没有这个值
    2010年2月3日 4:52
  • Then should find out how it's missing.
    2010年2月3日 14:29
  • Summary.txt

    Product                   : 数据库服务 (MSSQLSERVER)
    Product Version (Previous): 3042
    Product Version (Final)   :
    Status                    : 失败
    Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
    Error Number              : 29528
    Error Description         : MSP Error: 29528  安装程序在 正在设置内部属性 期间遇到错误。错误为: 安装时发生严重错误


    Try refer this article,
    http://support.microsoft.com/kb/925976



    2010年2月9日 4:09
    版主