SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL SP4 on Clustered environment
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

PremKannan
Starting Member

India
2 Posts

Posted - 04/26/2011 :  01:43:49  Show Profile  Reply with Quote
Hi
I am trying to upgrade the SQL 2005 [64bit] SP4, which is in Active/passive clustered environment. OS is Windows 2003 SP2.

while trying to upgrade I got the following error message
Time: 04/22/2011 02:36:25.226
KB Number: KB2463332
Machine: LDDB2
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x64
Package SP Level: 4
Package Version: 5000
Command-line parameters specified:
Cluster Installation: Yes
Log Location on Passive Nodes:
(LDDB2) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
(LDDB1) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
(LDDB2) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
(LDDB1) 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.4.5000 x64
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x64 ENTERPRISE
Analysis Services (MSSQLSERVER) ENU SP4 2005.090.5000.00 x64 ENTERPRISE
SQL Server Native Client ENU 9.00.5000.00 x64
Client Components ENU RTM 9.00.1399.06 x64 ENTERPRISE
Backward Compatibility ENU 8.05.2312 x64
Microsoft SQL Server VSS Writer ENU 9.00.5000.00 x64

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

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
msftesql Database Services Service 4128
MSSQLSERVER Database Services Service 1736
resrcmon.exe Database Services Application TVSLSL\clussvc 2860
SQLSERVERAGENT Database Services Service 4044

**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 5000
Product Version (Final) : 5000
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB2463332_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 5000
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 5000
Product Version (Final) : 5000
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB2463332_sqlncli.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB2463332_sqlrun_tools.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 2312
Product Version (Final) : 2312
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB2463332_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 5000
Product Version (Final) : 5000
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB2463332_SqlWriter.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

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

Kindly help me to upgrade SQL SP4


Thanks

PremKannan

T103988
Starting Member

1 Posts

Posted - 04/27/2011 :  14:58:17  Show Profile  Reply with Quote
Did you get this fixed? I'm having the same issue.
Go to Top of Page

PremKannan
Starting Member

India
2 Posts

Posted - 04/28/2011 :  06:03:44  Show Profile  Reply with Quote
quote:
Originally posted by T103988

Did you get this fixed? I'm having the same issue.


not yet, I am waiting.

Thanks

PremKannan
Go to Top of Page

robvolk
Most Valuable Yak

USA
15678 Posts

Posted - 04/28/2011 :  06:25:23  Show Profile  Visit robvolk's Homepage  Reply with Quote
You may want to re-download the SP4 package, it's possible it got corrupted and lost the file in question. If that does not fix it you should open a support incident with Microsoft.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000