December 9, 2015 at 7:55 am
I have a 2 server Windows 2008R2 cluster that has been running 3 instances of SQL Server 2008 and 4 instances of SQL Server 2012 for many months without problems. We added a third server to the cluster and I've been able to add all 4 SQL Server 2012 instances to this server using the 2012 "add a node to an existing SQL Server failover cluster" wizard. When I try to add the SQL Server 2008 instances using the 2008 wizard, only 1 instance appears in the Cluster Node Configuration dropdown (which installs fine). The other 2 instances are not found. Is there a registry, configuration, or AD setting that is missing on this server?
December 10, 2015 at 9:34 am
did you run a cluster validation report after adding the new node?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2015 at 9:23 am
Yes, a cluster verification was done and it contained warnings but no errors.
December 17, 2015 at 6:19 am
can you provide more information, screenshots maybe?
What does the failover cluster manager view show
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2016 at 1:41 pm
I found the problem - at some point these SQL instances must have encountered an error when patching or repairing and a registry key was set to indicate the error. Resetting the key from 2 to 1 solved the problem. The key is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.xxxxxxxxx\ConfigurationState
March 29, 2016 at 12:07 pm
Awesome!!. Thanks for sharing
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply