September 28, 2008 at 2:27 am
I have two instances of SQL Server 2005 version 9.00.3042 on a windows 2003 Enterprise Edition server service pack 1
The security Update detect both of the instances wherein one instance gets done but other gets failed.
Any idea!!
September 28, 2008 at 2:52 am
I have two instances of SQL Server 2005 version 9.00.3042 on a windows 2003 Enterprise Edition server service pack 1
The security Update MS08-040 detect both of the instances wherein one instance gets done but other gets failed.
Any idea!!
September 28, 2008 at 7:32 am
What is "gets done"? Do you mean updated?
This is what you want. We don't want to have to update all instances with patches. You apply the patch twice.
September 30, 2008 at 6:14 am
you should be able to patch both instances at once, did you select both detected instances?
Have you checked the patch log file to find out why it failed?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 2, 2008 at 4:06 am
Hi,
I am saying that setup dected all the instances but setup failed for one of the database services i..e one instance out of two. Please also note that both the nodes are on separate active\active clustered. I have tried with all the options like browsew service is online as it is not on clustered group, TCP ip is enabled in ms sql server configuration manager, and i have tried to put the virutual name and ip address of the node in LMHOSTS.sam file but still it is not working.
I am pasting below the text of Summary.txt file.
Please see if any has got any fix for it.
Time: 09/28/2008 06:51:54.039
KB Number: KB948109
Machine: KDCPSQL05N2
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x64
Package SP Level: 2
Package Version: 3068
Command-line parameters specified:
Cluster Installation: Yes
Log Location on Passive Nodes:
(KDCPSQL05N2) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
(KDCPSQL05N1) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
SQL Server Database Services 2005 (PAML) ENU SP2 2005.090.3068.00 x64 ENTERPRISE
SQL Server Database Services 2005 (PSQL02) ENU SP2 2005.090.3042.00 x64 ENTERPRISE
SQL Server Tools and Workstation Components 2005 ENU SP2 9.2.3068 x64 ENTERPRISE
**********************************************************************************
Products Disqualified & Reason
Product Reason
SQL Server Database Services 2005 (PAML) This installation must be run from the active node. You are running it from a passive node. To proceed, cancel the installation and run it again from the active node.
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
MSSQL$PSQL02 SQL Server Database Services Service 1820
**********************************************************************************
Product Installation Status
Product : SQL Server Database Services 2005 (PAML)
Product Version (Previous): 3068
Product Version (Final) :
Status : NA
Log File :
Error Description : This installation must be run from the active node. You are running it from a passive node. To proceed, cancel the installation and run it again from the active node.
----------------------------------------------------------------------------------
Product : SQL Server Database Services 2005 (PSQL02)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
----------------------------------------------------------------------------------
Product : SQL Server Tools and Workstation Components 2005
Product Version (Previous): 3068
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009
Thanks,
Santosh Singh
October 27, 2009 at 9:38 am
I am having exactly the same issue, same error, same configuration
October 27, 2009 at 9:48 am
**********************************************************************************
Products Disqualified & Reason
Product Reason
SQL Server Database Services 2005 (PAML) This installation must be run from the active node. You are running it from a passive node. To proceed, cancel the installation and run it again from the active node.
**********************************************************************************
Product Installation Status
Product : SQL Server Database Services 2005 (PAML)
Product Version (Previous): 3068
Product Version (Final) :
Status : NA
Log File :
Error Description : This installation must be run from the active node. You are running it from a passive node. To proceed, cancel the installation and run it again from the active node.
----------------------------------------------------------------------------------
Product : SQL Server Database Services 2005 (PSQL02)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
Did you read the Error Log thoroughly? It says that you have tried to run the Installation from one of the Node, and it has applied the patch on the Active Node (the Node you started the Installation)
So run the process on the other Node and it would apply the Active Instance on that node.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
October 28, 2009 at 12:01 pm
santosh_chandel (10/2/2008)
**********************************************************************************Products Disqualified & Reason
Product Reason
SQL Server Database Services 2005 (PAML) This installation must be run from the active node. You are running it from a passive node. To proceed, cancel the installation and run it again from the active node.
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
MSSQL$PSQL02 SQL Server Database Services Service 1820
**********************************************************************************
Product Installation Status
Product : SQL Server Database Services 2005 (PAML)
Product Version (Previous): 3068
Product Version (Final) :
Status : NA
Log File :
Error Description : This installation must be run from the active node. You are running it from a passive node. To proceed, cancel the installation and run it again from the active node.
Dude Santosh
you must read the error log, the issue is clear (highlighted in red for you 😉 ). Find the active node (check Windows cluster administrator for this) and re run the setup on this node,
regards
Pez
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2009 at 12:15 pm
I did exactly what you suggested, it is an active/active cluster. I ran it first on one node and it succeeded except for the the instances that were passive on that node, as expected, the log for Active instances said Status: Success. But when I ran it on the second node, it did not succeed for the active instances on that node, the log says Status: Failure, Error Description: No passive nodes were successfully patched.
October 28, 2009 at 12:19 pm
Lyn
its not a good idea to hijack another thread best to start your own. That aside can you post details of the setup log as Santosh has done Some idea of the Node names and instances of SQL Server installed would be helpful too.
regards
Pez
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply