Unable to Install SQL Failover Clustering RRS feed

  • Question

  • Hi

    I am trying to install SQL failover clustring on Windows 2008. Earlier SQL Stand alone was installed on the Server.

    Now when i tried to install SQL Failover, then while checking the setup support rules, i received few warning and one failure message.

    1. Distributed Transaction Co-ordinate MSDTC cluster :: Warning

    2. Microsoft Cluster service MSCS cluster verification error :: Failed

    3. Microsoft Cluster service MSCS cluster verification warning :: Warning

    4. Network binding order :: Warning


    Need some help ASAP in order to resolve these issue so that i can carry with SQL clustring on both Windows Server 2008 R2.

    Friday, August 20, 2010 12:31 PM


All replies

  • Hi rassac,

    Are you trying to install default instance in cluster?. Try to install named instance in SQL cluster because a default instance already existing.

    Ramesh S
    Friday, August 20, 2010 1:44 PM
  • Did you pass all tests when creating Windows failover cluster? Seems like something with Windows cluster, not SQL Server.
    • Marked as answer by rassac Saturday, August 21, 2010 6:04 AM
    • Unmarked as answer by rassac Saturday, August 21, 2010 6:04 AM
    Friday, August 20, 2010 1:47 PM
  • Hi Ramesh,


    I am not trying to install instance in cluster.

    I was trying to run complete new fail over clustering.

    Saturday, August 21, 2010 4:59 AM
  • Hi Rassac,

    Have you created MSDTC resource before sql cluster setup

    check this microsoft link for more details with prerequest.



    Ramesh S
    Saturday, August 21, 2010 5:44 AM
  • Hi All,

    While installing MSDTC services, its giving an option to select cluster node.

    Just wanted to know that do i need to create a new cluster for MSDTC or can i use the old cluster which were created while windows clustering was done?

    If i am selecting the olde cluster, then its being created but unable to bring it online and showing its status as failed.

    Error: Error code 0X80071736

    The resource failed to come online due to the failure of one or more provide resource.



    Saturday, August 21, 2010 6:13 AM
  • Hi,

    Create msdtc resource in windows cluster. There is no need to create additional cluster group for msdtc.


    Ramesh S
    Saturday, August 21, 2010 6:43 AM
  • Creating MSDTC before installing SQL Server is not necessarily. I configured MSDTC after installing SQL Cluster.
    Saturday, August 21, 2010 7:42 AM
  • Hi Serqey,

    how is it possible to configure SQL before MSDTC and MSCS, as when ever you start with SQL enterprise Failover it will check the setup rules and if these services are not activated.

    if possible kindly explain me the steps if this is possible.



    Saturday, August 21, 2010 9:41 AM
  • Hi rassac, we defenitely should configure MSCS before installation SQL Cluster but MSDTC is not required to run SQL Server. After installing SQL Cluster I added MSDTC to cluster groups and configured it properly.
    Saturday, August 21, 2010 10:49 AM
  • hi serqey, okay thats fine...but could u help me with steps in order to configure MSCS as i am unable to do so..and one more thing i want to confirm is that is it possible that due to installation of ADRMS on the server there might be any issue with both server's communication within AD?
    Saturday, August 21, 2010 1:59 PM
  • rassa, when you created Windows failover cluster, did you passed all tests correctly?
    Saturday, August 21, 2010 9:15 PM
  • Still an issue?


    Ed Price (a.k.a User Ed), SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Tuesday, April 16, 2013 4:33 PM