Have you had a good experience installing SQL server 2008 on a cluster? I have not. Three of the three installs I have done have failed for various reasons. The cause I have seen so far is that if the name of the application group exists in DNS prior to adding it the install is going to fail.. But that isn’t the worst part… Once the SQL install fails you are in trouble because the install check points in the Registry. I had to call Microsoft on two of the installs I did. On the first install I got the message “Failover instance XYZ cluster group not found” while I was trying to add the second node of my Active-Active cluster. It turned out as I said that the cluster group had already been added to DNS so the SQL install failed because it tried to create it for me. I had to go into the registry and change values from 2 to 1 for the following keys:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQLX.MSSQLSERVER\ConfigurationState
MPT_AGENT_CORE_CNI
SQL_Engine_Core_Inst
SQL_FullText_Adv
SQL_Replication_Core_Inst
Posted by motherofallgeeks 
