cluster logical diagram (SQL 2005 2 node cluster - windows 2003

Posted on 2009-04-29
Last Modified: 2012-05-06
In order to explain to someone the bigger picture of how to configure or setup the SQL 2005 2 node cluster i need to draw a picture on papar that how it will be build. Not the step by step but just a bigger picture.

I will appreciate if someone can give me logical diagram of cluster with virtual servers and nodes in it like which explain what is require to setup sql cluster (2 nodes). Thanks
Question by:tech2010
    1 Comment
    LVL 12

    Accepted Solution

    You will setup Windows clustering using Windows 2003 enterprise server OS CDs.
    You will have to setup two systems abnd then configure Windows clustering after.
    Here's a link you can use:

    You will need a centralised storage system. I have attached a simple hand drawn diagram to make you understand the setup.
    I will explain the difference between a NAS ad a SAN:
    A NAS is a Network Attached Storage. This is a storage system that runs on data files. An example is a NetApp machine.
    A NAS is just like a SAN (Storage Area Network) in concept but a NAS operates on data files while the SAN operates on disk blocks.
    The SAN also allows access to logical volumes via Fibre Channel interconnects while a NAS does so via TCP and also supports Ethernet.
    I have attached a sample of the diagram.


    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
    A quick step-by-step overview of installing and configuring Carbonite Server Backup.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    745 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

    14 Experts available now in Live!

    Get 1:1 Help Now