sql server cluster node rebuild failure :(

[snomad]

Hi all,

I had a node failure and rebuild on a sql server 2005 2 node cluster.
the server has been rebuilt with new os. i evicted then re-added the
rebuilt node via cluster administrator. i cannot not reinstall sql
server (or failover).

Failover fails because the sql server resources are not owned by the
rebuilt node. There is no option to add in the new node as a possible
owner because the rebuilt node does not exist in the modify list.
Maybe this is normal because the rebuilt node no longer has sql server
on it.

So, then i tried to install sql server via 2 methods:

1. via add\remove progs on old, good node. change . . . takes me
through to 'maintain virtual server' but i enter the VS name and it
errors with 'name not valid'. presumably because it is not unique?
clearly i don't want to create a new one.

2. via set up on new rebuilt node. same problem. i cannot get past
the virtual server.

Have rebooted, evicted & readded . . . users inc. service accounts =
local admin etc. etc.

Can't find anything useful on tinterweb. Can anyone help?????

Thank you!

[sqlmonkey]

Re: sql server cluster node rebuild failure :(

http://www.microsoft.com/downloads/details.aspx?familyid=818234DC-A17B-4F09-B282-C6830FEAD499&displaylang=en

Make sure have read and understand this.

when you run select * from sys.dm_os_clust er_nodes do you still see
the old node. I suspect you do.
I suspect that quickest route would be to remove SQL from the cluster
(using setup) and re-add it (using setup).
What does the application event log say btw.


On Oct 10, 3:28 pm, snomad <jessboswo...@h otmail.comwrote :

Hi all,
>
I had a node failure and rebuild on a sql server 2005 2 node cluster.
the server has been rebuilt with new os.  i evicted then re-added the
rebuilt node via cluster administrator. i cannot not reinstall sql
server (or failover).
>
Failover fails because the sql server resources are not owned by the
rebuilt node.  There is no option to add in the new node as a possible
owner because the rebuilt node does not exist in the modify list.
Maybe this is normal because the rebuilt node no longer has sql server
on it.
>
So, then i tried to install sql server via 2 methods:
>
1. via add\remove progs on old, good node.  change . . .  takes me
through to 'maintain virtual server' but i enter the VS name and it
errors with 'name not valid'.  presumably because it is not unique?
clearly i don't want to create a new one.
>
2. via set up on new rebuilt node.  same problem.  i cannot get past
the virtual server.
>
Have rebooted, evicted & readded . . . users inc. service accounts =
local admin etc. etc.
>
Can't find anything useful on tinterweb.  Can anyone help?????
>
Thank you!