SP3 install fails on 2005 failover cluster

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SP3 install fails on 2005 failover cluster

Author

Topic

paulland
Starting Member

7 Posts

Posted - 2009-03-10 : 15:43:12

Hi -- I'm unable to get SP3 to install on my SQL 05 (i86) failover cluster. The summary reads:

**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009

I'm providing a remote user account during the install process with full admin rights on the passive node (same login as on the active node, same user who originally installed SP2).

When I go to the log file on the passive node, there is no evidence that the patch was even attempted. The last entry in the log is for the previous install of SP2. I verified login and comm to the passive node and was able to successfully move the SQL group between nodes after the failed install.

Is there a way to force the install on the passive node? Or to determine why the update doesn't start?

Thanks

Contents of summary log on active node:

Time: 03/10/2009 02:21:39.114
KB Number: KB955706
Machine: MVIPADB01
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 3
Package Version: 4035
Command-line parameters specified:
Cluster Installation: Yes
Log Location on Passive Nodes:
(MVIPADB01) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
(MVIPADB02) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.2.3042 x86
Database Services (MSSQLSERVER) ENU SP2 2005.090.3042.00 x86 STANDARD
Integration Services ENU SP2 9.00.3042.00 x86 STANDARD
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU SP2 9.2.3042 x86 STANDARD
MSXML 6.0 Parser ENU 6.10.1129.0 x86
SQLXML4 ENU 9.00.3042.00 x86
Backward Compatibility ENU 8.05.2004 x86
Microsoft SQL Server VSS Writer ENU 9.00.3042.00 x86

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
SQLWriter Microsoft SQL Server VSS Writer Service NT AUTHORITY\SYSTEM 2296

**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 3042
Product Version (Final) : 4035
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB955706_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 3042
Product Version (Final) : 4035
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB955706_sqlrun_dts.msp.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) : 4035
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB955706_sqlncli.msi.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 3042
Product Version (Final) : 4035
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB955706_sqlrun_tools.msp.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 1129
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 3042
Product Version (Final) : 4035
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB955706_sqlxml4.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 2004
Product Version (Final) : 2312
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB955706_SQLServer2005_BC.msi.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 3042
Product Version (Final) : 4035
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB955706_SqlWriter.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009

*****************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009

heavymind
Posting Yak Master

115 Posts

Posted - 2009-03-10 : 16:18:17

check out this http://db-staff.com/index.php/microsoft-sql-server/87-upgrade-sql-2005-cluster-to-sp3 topic and try to reboot both nodes and proceed.

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources