InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 17:15:04 GMT20http://www.sqlservercentral.com/Forums/Topic733865-54-1.aspxPlease refer the Article:http://support.microsoft.com/kb/929151Tue, 03 May 2011 04:56:26 GMTramgckhttp://www.sqlservercentral.com/Forums/Topic733865-54-1.aspxThe solution worked for me is removing the possible owners of other nodes and keeping only the node which to applied Service packFri, 21 Aug 2009 22:19:26 GMTsivaprasadhttp://www.sqlservercentral.com/Forums/Topic733865-54-1.aspxHi oscar-powell,I'm having the same situation in an UAT cluster configured as Active/Passive. I wanted to install SP3 last sunday and I got the same error: No passive nodes were successfully patched.What I do found (but didn't try it yet) was a workaround. That was to go into the Cluster Admin, go to the SQL Server resource and remove all the available servers but one, so you serve the resource with only one server (no actual cluster there...). Then, perform the update on each server. Because you don't have the instance in a cluster environment, the SP3 will not try to update the passive node. Finally, go back to the resources and set everything as you have before....I know this is not a good way, but perhaps this can help...Cheers,AlejandroFri, 12 Jun 2009 08:59:56 GMTAle Pelchttp://www.sqlservercentral.com/Forums/Topic733865-54-1.aspxAttempted to install SP3 on a SQL Server 2005 Cluster, and the attempt failed. Here is my request. I need some help finding offical microsoft documentation on testing that a SQL Cluster is talking back and forth. Can someone point me in the right direction for this type information. Background:I attempted to update a SQL cluster running SQL Server 2005 SP2. I followed all the nice pretty boxes. and when the upgrade attempt was completed the update to SQL Server engine had failed with a error.Exit Code Returned: 11009------- Summary.txtTime: 06/11/2009 17:20:52.558KB Number: KB955706Machine: EGLSQLTEST1OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790)Package Language: 1033 (ENU)Package Platform: x86Package SP Level: 3Package Version: 4035Command-line parameters specified:Cluster Installation: YesLog Location on Passive Nodes:(EGLSQLTEST1) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix(EARSQLTEST1) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix**********************************************************************************Prerequisites Check & StatusSQLSupport: Passed**********************************************************************************Products Detected Language Level Patch Level Platform EditionSetup Support Files ENU 9.3.4035 x86 Database Services (MSSQLSERVER) ENU SP2 2005.090.3077.00 x86 ENTERPRISEIntegration Services ENU SP3 9.00.4035.00 x86 ENTERPRISESQL Server Native Client ENU 9.00.4035.00 x86 Client Components ENU SP3 9.3.4035 x86 ENTERPRISEMSXML 6.0 Parser ENU 6.20.1099.0 x86 SQLXML4 ENU 9.00.4035.00 x86 Backward Compatibility ENU 8.05.2312 x86 Microsoft SQL Server VSS Writer ENU 9.00.4035.00 x86 **********************************************************************************Products Disqualified & ReasonProduct Reason**********************************************************************************Processes Locking FilesProcess Name Feature Type User Name PIDmsftesql Database Services Service 2708resrcmon.exe Database Services Application MTGA\ClusterAdmin 3452**********************************************************************************Product Installation StatusProduct : Setup Support FilesProduct Version (Previous): 4035Product Version (Final) : Status : Not SelectedLog File : Error Description :----------------------------------------------------------------------------------Product : Database Services (MSSQLSERVER)Product Version (Previous): 3077Product Version (Final) : Status : FailureLog File : Error Number : 11009Error Description : No passive nodes were successfully patched----------------------------------------------------------------------------------SummaryNo passive nodes were successfully patchedExit Code Returned: 11009There was no hotfix.log generated..Just need to now how to ensure this does not happen in production at somepointFri, 12 Jun 2009 08:04:26 GMTSirFalcon60