Hi John

Thanks for your response. I've stumbled across the databasejournal thread
too. But as I've never uninstalled the Setup Support files bevore I
couldn't estimate the risk involved. And because this is production I
didn't like to take a chance...

But now I will give it a shot and let you know the outcome.

Maintenance window is on 11. December

Thanks so far
Daniel




"Eisbrener John " <[Email address protected]
28.11.2007 16:08

To
DANIEL.[Email address protected]
cc

Subject
RE: Additional Windows Cluster Node refuses to install SQL 2005 SP2






**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


Hi Daniel,

I've not done this before, but I will have to in the future, so if you do
find a solution, let me know. In the meantime, I've found this tread:
http://forums.databasejournal.com/showthread.php?threadid=47290

What this basically says is that you should uninstall the SQL Setup
Support
Files on the existing nodes, then reinstall them using the SQLSupport.msi
installer on the SQL 2005 installation disk(s)/path. For a more formal
instruction list refer to this KB article:
http://support.microsoft.com/kb/918357

This KB article discusses an error that happens when you try to reapply
SP1,
but to me it looks like the exact same issue as the one you're running
into.
I've performed the steps in this KB article multiple times to both my Test
and Production clusters with no ill affects what so ever. If you give
this a
shot, let me know if it works for you or not.

Thanks,

John Eisbrener
SQL Database Administrator
Capitol Insurance Companies


-----Original Message-----
From: Daniel Kast
[Email address protected]
Sent: Wednesday, November 28, 2007 7:30 AM
To: LazyDBA Discussion
Subject: Additional Windows Cluster Node refuses to install SQL 2005 SP2

I have a SQL Server 2005 Cluster with SP2 and CU2 (KB936305 Build 3175)

Now I've added an additional Node. The Windows part went through like a
charm and the new node is recognized by the MSCS.
The addition of the new node to the SQL Server Ressource through
Add/Remove Programs (as described in SQL Books Online) installed the SQL
Server binaries from build 1399 (RTM) on the new node.

Starting SQL Server 2005 SP2 setup on the "new" node shows Database Engine
(1399) and offers the upgrade. It then first tries to update the passive
"old" node and failes with the errormessage: No passive nodes were
successfully patched, Exit Code Returned: 11009
Then the SP2 setup stops without updating the "new" node.

Re-Applying SQL Server 2005 SP2 on the "old" node is not possible as the
dialog states that the Database Engine (3175) is already newer.

Someone experienced the same and has a fix for this?


Regards
Daniel

**********************************************************************
This e-mail may contain confidential material. It is intended only for the
person or entity which it is addressed to. Any review, retransmission,
dissemination or other use of this information by persons or entities
other
than the intended recipient is prohibited. If you received this e-mail in
error, please immediately notify the sender or The Swiss Raiffeisen Group
and
delete the material from any and all computers it may be stored on. Any
views
or opinions expressed in this e-mail are those of the sender and do not
necessarily coincide with those of The Swiss Raiffeisen Group. Therefore
this
e-mail does not represent a binding agreement nor an offer to deal. E-mail
transmission cannot be guaranteed to be secure or error-free. Information
could be intercepted, corrupted, lost, destroyed, incomplete or may
contain
viruses. Neither The Swiss Raiffeisen Group nor the sender can accept any
liability for any kind of damage as the result of viruses or transmission
errors.
**********************************************************************



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page