Cannot add second node to cluster

Question

Cannot add second node to cluster

Steven Cuthbertson

Mr or Mrs. 500

Points: 578
More actions
July 26, 2007 at 2:30 pm

#179940

Hi everyone:
I am installing an SQL 2005 failover cluster using two server 2003 Enterprise Edition servers and a SAN as a quorum. I have the cluster configured and everything worked fine, but when I tried to add the second node to the cluster it fails at the system configuration check (SCC). All of the checks on the second node fail with the message "unable to process the check" and then in "maintain the virtual server" it lists the node in the unavailable nodes section.
If I try to install a custer from the second node, I get the same messages about the first node, which is already running SQL. I have tried evicting and reconfiguring the second node, but it is no different.
Any ideas?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Rich Hansell SSCrazy Points: 2346 More actions · Answer 1

Did you install SQl prior to clustering the two servers? Set up the cluster with SAN drives set up for the qourum, the data and the logs. Then install SQL2005, it is a cluster aware install. Also make sure you have task scheduler running on both nodes prior to installing so it will install on both nodes.

Steven Cuthbertson Mr or Mrs. 500 Points: 578 More actions · Answer 2

I have had SQL on both servers previously, but I uninstalled them both, configured the cluster, then reinstalled as a cluster. Node1 went on fine, but node2 didn't install, with the errors given.

I don't know about the task scheduler option - I expect it is running, I think that's default? What does task scheduler bring to the cluster party?

Rich Hansell SSCrazy Points: 2346 More actions · Answer 3

Having the task scheduler running during install will allow it to install on the second node, but it would probably render a different error(well, it did for me)

Did you look at the logs it(setup) generated?

Steven Cuthbertson Mr or Mrs. 500 Points: 578 More actions · Answer 4

Rich:

Turned out to be ISA server (now how often do you hear that?). I had seen another article provoking the same problem, but I couldn't see anything being blocked by ISA in monitoring, so I kind of eliminated it. Anyway, I stripped ISA off and it passed the SCC check, allowing me to add the 2nd node.

Thanks for your help.

Steve