November 18, 2012 at 6:49 pm
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.
November 18, 2012 at 8:25 pm
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.
November 19, 2012 at 5:15 am
Those were the exact steps I followed. Hopefully today is a better day....txtPost_CommentEmoticon(':-)');
November 19, 2012 at 5:48 pm
This was fixed today. It was due to a missing Security Group in Active Directory.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply