MNS and SQL

Discussion in 'Clustering' started by Drew B., Jul 20, 2004.

  1. Drew B.

    Drew B. Guest

    We are trying to install SQL on our three-node Windows
    2003 Server cluster. We are using Majority Node Set
    because we do not have a physical disk attached to use as
    the quoram resource. When we try to install SQL and we
    get to the part of the installation process where it asks
    you to "select a cluster disk where data files will be
    placed", there is nothing listed. Is it possible to set
    up SQL on a cluster using MNS?
     
    Drew B., Jul 20, 2004
    #1
    1. Advertisements

  2. MNS & SQL is not supported. Sorry. Think 3rd party.

    Cheers,

    Rod

    MVP - Windows Server - Clustering
    http://www.nw-america.com - Clustering
     
    Rodney R. Fournier [MVP], Jul 20, 2004
    #2
    1. Advertisements

  3. SQL requires shared disk(s) for the database and logs.
     
    Russ Kaufmann [MCT], Jul 20, 2004
    #3
  4. Drew,

    Consider MNS as a new "quorum type" i.e. quorum resource can be either of
    type "Majority Node Set" or of type "Physical Disk".

    Even though for a MNS based cluster you do not need a shared disk (more
    appropriately - a resource of type "Physical Disk") for quorum, you will
    still need shared disks for resources of other types like Exchange, SQL,
    File Share etc.

    --
    Regards,
    Shon Shah
    Software Design Engineer/Test
    Microsoft Cluster Server

    This posting is provided "AS IS" with no warranties, and confers no rights.
    Use of included script samples, if any, are subject to the terms specified
    at http://www.microsoft.com/info/cpyright.htm
     
    Shon Shah [MSFT], Jul 23, 2004
    #4
  5. Drew B.

    Eugene Smith Guest

    Rod;

    I would be interested to know your references that SQL and
    MNS are not supported. We are currently running SQL 2000
    with Windows Server 2003, Enterprise and using the MNS.
    I have not run into a problem as yet... but would like to
    know for further/future reference. Thanks

    Regards
    Eugene
     
    Eugene Smith, Jul 23, 2004
    #5
  6. I can't find anything on the web that states one way or the other. Though I
    can not find a single article that says anything about SQL & MNS. I first
    heard it from several Microsoft employees. Maybe one will chime in here.

    Cheers,

    Rod

    MVP - Windows Server - Clustering
    http://www.nw-america.com - Clustering
     
    Rodney R. Fournier [MVP], Jul 23, 2004
    #6
  7. I would point to th fact that with two servers in a cluster, the cluster can
    not survive a single failure because majority can not be reached. In a two
    node cluster, a single node failure will result in a complete failure.

    I would also point the fact that SQL requires a shared disk for the
    database.
     
    Russ Kaufmann [MCT], Jul 26, 2004
    #7
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.