Inside a virtual environment running Windows 2008r2 Ent SP1 and SQL 2008r2 RTM.
Inintial cluster build has gone smoothly for a 2 node cluster using iSCSI. Added up a third node to this cluster manually changed quorum model and MsDTC resource was bouncing all well on the three nodes. Sweat started when the third node failed to add
into SQL Failover cluster with the given message "Failed to retrieve data for this request" right after clicking add a node.
Sites talk about adding CuP6 and to lower the security but to note all this worked for first & when adding second node, for the moment this was resolved for me after I restarted all the nodes; going from Node3 to 1. For a moment RemoteRegistry service
failed to start on node2 and it wount work even on restarts so moved every thing to node1 now the RPC was up on Node2 and I can go further on adding node3 to SQL cluster but as I'm typing it failed again.
As I check the logs they point about failures to write to registry and at time Network Path not found, User credentials used are all same and pings are going well for the entrire set of IP's I have.
Any insights on this are highly appreciated?
View Complete Post