locked
Unable to Install SQL Failover Clustering RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

Answers

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    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
    www.sequalserver.com
    Friday, August 20, 2010 1:44 PM
  • Question
    Sign in to vote
    2
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Rassac,

    Have you created MSDTC resource before sql cluster setup

    check this microsoft link for more details with prerequest.

    http://msdn.microsoft.com/en-us/library/ms189910.aspx

     

    Ramesh S
    www.sequalserver.com
    Saturday, August 21, 2010 5:44 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

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

    http://technet.microsoft.com/en-us/library/cc982683%28BTS.10%29.aspx

    Ramesh S
    www.sequalserver.com
    Saturday, August 21, 2010 6:43 AM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Creating MSDTC before installing SQL Server is not necessarily. I configured MSDTC after installing SQL Cluster.
    Saturday, August 21, 2010 7:42 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

     

    Thanks

    Saturday, August 21, 2010 9:41 AM
  • Question
    Sign in to vote
    1
    Sign in to vote
    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
  • Question
    Sign in to vote
    1
    Sign in to vote
    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
  • Question
    Sign in to vote
    1
    Sign in to vote
    rassa, when you created Windows failover cluster, did you passed all tests correctly?
    Saturday, August 21, 2010 9:15 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Still an issue?

    Thanks!

    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