SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2005 Cluster - Removing / Rebuilding / Adding Node


SQL Server 2005 Cluster - Removing / Rebuilding / Adding Node

Author
Message
SQLSeTTeR
SQLSeTTeR
SSC-Addicted
SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)

Group: General Forum Members
Points: 451 Visits: 1391
We have a two node SQL Server 2005 SP2 cluster, Running Windows Server 2003 SP1. My company implemented a new EMC SAN which required for all the servers running 2003 server SP1 being upgraded to SP2. Today, while upgrade ONE of our clusters to SP2, the boot-up got stuck on the Windows splash screeen. The server folks attempted to uninstall, but the server remained unhappy. To make a long story short the server was rebuilt. It was rebuilt using the hostname as before and successfully upgraded to SP2, while the primary node is up and owning all the clustered resources. When the server was handed over to me, I RDP'd into the primary and attempted to add SQL Instances onto new node. All was going well until I bumped into an issue when it attempts to validate the Service accounts "A domain group is missing for one or more services. To Install SQL Server 2005 as a Failover Cluster, domain groups must be specified for all the clustered services being installed. To proceed, enter the missing domain group information. The domain group cannot be validated for the server SQL Server." The account I am using is a domain admin account and is a member of multiple groups. Further, this account is used on ALL of our Production clusters. Could the problem be an issue with the SID? Something embedded in the registry of the primary node because we are using the same hostname? When the built the node they installed SP2, while the primary is still on SP1? Any help is much appreciated. I am at a loss.
mnDBA
mnDBA
SSC-Enthusiastic
SSC-Enthusiastic (188 reputation)SSC-Enthusiastic (188 reputation)SSC-Enthusiastic (188 reputation)SSC-Enthusiastic (188 reputation)SSC-Enthusiastic (188 reputation)SSC-Enthusiastic (188 reputation)SSC-Enthusiastic (188 reputation)SSC-Enthusiastic (188 reputation)

Group: General Forum Members
Points: 188 Visits: 796
A couple of quick questions.

1. Is the account you are logged in as a local admin on both of the cluster nodes?
2. It has been a while since I have dealt with the death of a cluster node. I would go through the SQL Server install and remove, presuming it is still there, the node that died from the Cluster Node Configuration. Then reinstall. Directions for removing the node can be found here. http://msdn.microsoft.com/en-us/library/ms191545(v=sql.90).aspx

Hope this helps.
SQLSeTTeR
SQLSeTTeR
SSC-Addicted
SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)

Group: General Forum Members
Points: 451 Visits: 1391
Those were the exact steps I followed. Hopefully today is a better day....txtPost_CommentEmoticon(':-)');
SQLSeTTeR
SQLSeTTeR
SSC-Addicted
SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)

Group: General Forum Members
Points: 451 Visits: 1391
This was fixed today. It was due to a missing Security Group in Active Directory.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search