Solved

Create a SQL Server Cluster

Posted on 2007-11-14
2
530 Views
Last Modified: 2010-05-18
I am trying to setup a cluster of sql server databases.  I am kinda going into this blind, so far i have installed the default instance of sql server enterprise edition in mixed mode, on a server that is not connected to a network.  The cluster will be based on sql server instances across the country.

When i opent he cluster administrator, i create a new cluster, and it asks me what domain i am a part of, i am not a memver, I dont know what this means, so this would be where i would need to start i am assuming.
0
Comment
Question by:rodmjay
2 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 20278389
> The cluster will be based on sql server instances across the country.

a cluster can only be setup on nodes that are already clustered on the windows level.
for this to work "across the country", you will need them connected and visible to each other, including the quorum resource...

is that the case?
0
 
LVL 70

Accepted Solution

by:
KCTS earned 500 total points
ID: 20278464
You seem to be missing some pretty fundamaental stuff. take a l,ook at http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx which has a step by step guide.

BTW All machines that are in the cluster must be Windows 2003 Server Enterprise Edition and must conform to the hardware requirements for clustering. If you want more than a simple cluster then SQL has to be the Enterprise Edition as well.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now