SQL 2008 cluster with out joing server to Active Directory

Posted on 2011-10-26
Last Modified: 2012-05-12
Can I create the SQL 2008 cluster without joining  the server to the domain. When I tried to make the win 2008 fail over cluster the win 2008 r2 server asking me to join the server to domain since the cluster setting is stored in the AD. I do not have AD in this case how can I do the SQL 2008 cluster.If possible give me the step by step guide with pic.
Question by:jobby1
    LVL 39

    Expert Comment

    by:Krzysztof Pytko
    You need to have Active Directory environment if you wish to install SQL failover cluster. This is required because this kind of cluster relies on AD and DNS server.

    So, before that, you need to establish AD environment. Do you have a serer for that? If so, you may follow an article on my blog, how to create forest root domain at

    then you will be able to create SQL failover cluster.

    LVL 7

    Expert Comment

    Windows and SQL Server have a core requirement of AD and there isn't some way to hack around that.  However, have you considered database mirroring?  Mirroring is a better solution a lot of times than clustering anyways, and provides safety for disk failure whereas clustering does not.  Clustering also requires enterprise Windows Server software which is very expensive.

    Author Comment


    How can I do database mirroring. Can mirroring support fail over of the db server in case of failure of one DB server.
    LVL 7

    Accepted Solution

    Hi Jobby,

    Mirroring can provide application level failover actually, it's a very good piece of technology.  Just like clustering, it takes some setting up to do but a witness server can see that one is down, and immediately move you to the other node.  You have 2 types of mirroring, synchronous and asynchronous.  If you don't have a full time DBA on hand, you'll want to go Asynch.  Synch mirroring requires the transaction to commit on the mirrored copy first, before applying to the primary and if something goes down, your primary will hang up.  Asynch doesn't require for the transaction to commit on the failover, but you will lose 'in flight' transactions when it fails over, basically the last transaction or so will be lost, but nothing else.  This is a good start here:

    good video here:

    let us know if you need more help after reviewing it.  Good luck!  

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
    This tutorial will give a short introduction and overview of Backup Exec 2014 and the additional features that have been added over its predecessor Backup Exec 2012. As with Backup Exec 2012, the Backup Exec button in the upper left corner. From her…
    This tutorial will show how to inventory, catalog, and restore media from legacy versions of Backup Exec into both 2012 and 2014 versions of the software. Select Storage from the tabs along the ribbon bar as the top: Ensure the proper storage devi…

    737 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

    20 Experts available now in Live!

    Get 1:1 Help Now