<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SQL Server 2005 Security
»
I have two instances of SQL Server 2005...
I have two instances of SQL Server 2005 version 9.00.3042 on a windows 2003 Enterprise Edition server service pack 1
Rate Topic
Display Mode
Topic Options
Author
Message
santosh_chandel
santosh_chandel
Posted Sunday, September 28, 2008 2:27 AM
Grasshopper
Group: General Forum Members
Last Login: Monday, July 30, 2012 5:01 AM
Points: 11,
Visits: 85
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
santosh_chandel
santosh_chandel
Posted Sunday, September 28, 2008 2:52 AM
Grasshopper
Group: General Forum Members
Last Login: Monday, July 30, 2012 5:01 AM
Points: 11,
Visits: 85
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
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Sunday, September 28, 2008 7:32 AM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 9:03 PM
Points: 31,406,
Visits: 13,723
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
Perry Whittle
Perry Whittle
Posted Tuesday, September 30, 2008 6:14 AM
SSCertifiable
Group: General Forum Members
Last Login: 2 days ago @ 2:33 PM
Points: 5,201,
Visits: 11,150
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
santosh_chandel
santosh_chandel
Posted Thursday, October 02, 2008 4:06 AM
Grasshopper
Group: General Forum Members
Last Login: Monday, July 30, 2012 5:01 AM
Points: 11,
Visits: 85
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
lyn.williams
lyn.williams
Posted Tuesday, October 27, 2009 9:38 AM
Forum 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
Bru Medishetty
Bru Medishetty
Posted Tuesday, October 27, 2009 9:48 AM
SSCommitted
Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,735,
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
Perry Whittle
Perry Whittle
Posted Wednesday, October 28, 2009 12:01 PM
SSCertifiable
Group: General Forum Members
Last Login: 2 days ago @ 2:33 PM
Points: 5,201,
Visits: 11,150
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
lyn.williams
lyn.williams
Posted Wednesday, October 28, 2009 12:15 PM
Forum 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
Perry Whittle
Perry Whittle
Posted Wednesday, October 28, 2009 12:19 PM
SSCertifiable
Group: General Forum Members
Last Login: 2 days ago @ 2:33 PM
Points: 5,201,
Visits: 11,150
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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
