October 10, 2008 at 8:31 am
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.
Can't find anything useful on tinterweb. Can anyone help?????
Thank you!
🙂
October 21, 2008 at 8:14 am
Did you actually install SQL on the new box as part of a cluster or a standalone server? This is one of the options upon install. If you didn't choose "Cluster" then that's why you can't get it added properly.
Some keywords to Google would be Installing SQL Server as cluster & rebuild SQL Server cluster node.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply