Clustering issues
Hello experts,
I need some guidelines concerning the setup of a cluster on 2 servers. The main purpose is to create an sql failover cluster in the end. At the moment i am testing this and i have lot of time in order to make this work. So i ll try to point out what i have done so far, hoping that you will tell me what extra thigns i need to do :)
I have created 2 Vmware servers with 3 physicak disks on each one. The first one is the local where i have installed the O/S (win 2003 enterprise edition). The 2nd one i called it Quorum and the 3rd Data. I also added 2 network cards. 1 for the public network and 1 for the private (heartbeat). For shared storage i have a network disk that i could use.
So far i setup the 2 servers with their IPs (public and private). Their names are SQLN1 and SQLN2.
Then i opened cluster administration from admin tools and i tried to ceate the cluster. In this step i faced the first problem. When i add the first node (2nd node is offline) on cluster setup i get a warning that says " Could not locate a sharable quorum resource and a local quorum cluster will be created". If i ignore this and i continue in order to add the 2nd node, the 2nd node will fail to be added to the cluster.
I fail also to understand clearly what is the purpose of the quorum. Is it supposed to be a sharable drive that both servers see, or it is a local drive for each server that is used only for the clustering?
Thanx in advance for any help.
I need some guidelines concerning the setup of a cluster on 2 servers. The main purpose is to create an sql failover cluster in the end. At the moment i am testing this and i have lot of time in order to make this work. So i ll try to point out what i have done so far, hoping that you will tell me what extra thigns i need to do :)
I have created 2 Vmware servers with 3 physicak disks on each one. The first one is the local where i have installed the O/S (win 2003 enterprise edition). The 2nd one i called it Quorum and the 3rd Data. I also added 2 network cards. 1 for the public network and 1 for the private (heartbeat). For shared storage i have a network disk that i could use.
So far i setup the 2 servers with their IPs (public and private). Their names are SQLN1 and SQLN2.
Then i opened cluster administration from admin tools and i tried to ceate the cluster. In this step i faced the first problem. When i add the first node (2nd node is offline) on cluster setup i get a warning that says " Could not locate a sharable quorum resource and a local quorum cluster will be created". If i ignore this and i continue in order to add the 2nd node, the 2nd node will fail to be added to the cluster.
I fail also to understand clearly what is the purpose of the quorum. Is it supposed to be a sharable drive that both servers see, or it is a local drive for each server that is used only for the clustering?
Thanx in advance for any help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Do you know from where i can download the scsi driver for the scsi setup on the windows setup? On the manual the link that gives, spot on the vmware workstation installation
ASKER
Nvm i found it
ASKER
This was a perfect guide. Everything worked fine. Now i am trying to create the sql failover cluster. Thanx for your help :)
ASKER
So far i have created 2 virtual machines , 1 for each node but nothing else. This guide looks very nice. i ll follow it step by step. I ll keep this question a bit more open just in case i ll have something else to ask :)