I'm adding a 3rd new node to an existing SQL 2000 Enterprise SP4 cluster on Windows 2003 Enterprise SP2 R2. It is a two node Active/Passive.
SERVER1 and SERVER2 will be the current cluster
SERVER3 is the new node i'm adding.
I have the SERVER3 added and was able to install SQL 2000 Enterprise on this new passive node. I was also able to Apply Service Pack 1, and Service Pack 2 without issue. When applying Service Pack 3 I get the following errors
"All cluster disks available to this virtual server are owned by other node(s)"
I click ok and get
"Setup was unable to verify the state of the server for an upgrade. Verify the server is able to start and that you have provided a valid sa password and restart setup"
I've already read through http://support.microsoft.com/kb/811168
From what I can guess, I'm thinking I need to be on the current Active node (SERVER1). Then run the Service Pack 3 update from there and it will copy the right binaries to my new node (SERVER3). I'm not sure how it affects the current cluster since it's already at SP4 level.
Move the SQL Active Group from (SERVER1) over to the new passive node (SERVER3) and upgrade Service Pack 3 on SERVER3 which is the active node now. Although I'm thinking this will break something since SERVER1 currently has SP4 and failing it over to the passive node (SERVER3) with only SP2 currently on it will cause issues