InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 14:37:40 GMT20http://www.sqlservercentral.com/Forums/Topic1386123-391-1.aspxThis was fixed today. It was due to a missing Security Group in Active Directory.Mon, 19 Nov 2012 17:48:16 GMTSQLSeTTeRhttp://www.sqlservercentral.com/Forums/Topic1386123-391-1.aspxThose were the exact steps I followed. Hopefully today is a better day....txtPost_CommentEmoticon(':-)');Mon, 19 Nov 2012 05:15:12 GMTSQLSeTTeRhttp://www.sqlservercentral.com/Forums/Topic1386123-391-1.aspxA 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).aspxHope this helps.Sun, 18 Nov 2012 20:25:05 GMTmnDBAhttp://www.sqlservercentral.com/Forums/Topic1386123-391-1.aspxWe 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.Sun, 18 Nov 2012 18:49:23 GMTSQLSeTTeR