Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

I have two instances of SQL Server 2005 version 9.00.3042 on a windows 2003 Enterprise Edition server service pack 1 Expand / Collapse
Author
Message
Posted Sunday, September 28, 2008 2:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 12:49 AM
Points: 11, Visits: 90
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!!
Post #577377
Posted Sunday, September 28, 2008 2:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 12:49 AM
Points: 11, Visits: 90
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!!
Post #577378
Posted Sunday, September 28, 2008 7:32 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 9:15 AM
Points: 31,181, Visits: 15,624
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #577403
Posted Tuesday, September 30, 2008 6:14 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:16 AM
Points: 6,473, Visits: 13,930
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"
Post #578224
Posted Thursday, October 2, 2008 4:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 12:49 AM
Points: 11, Visits: 90
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
Post #579540
Posted Tuesday, October 27, 2009 9:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 28, 2009 12:06 PM
Points: 3, Visits: 3
I am having exactly the same issue, same error, same configuration
Post #809414
Posted Tuesday, October 27, 2009 9:48 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,646, Visits: 1,947

**********************************************************************************
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.



Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Post #809425
Posted Wednesday, October 28, 2009 12:01 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:16 AM
Points: 6,473, Visits: 13,930
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"
Post #810191
Posted Wednesday, October 28, 2009 12:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 28, 2009 12:06 PM
Points: 3, Visits: 3
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.
Post #810207
Posted Wednesday, October 28, 2009 12:19 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:16 AM
Points: 6,473, Visits: 13,930
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"
Post #810211
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse