Wednesday, October 22, 2014

27 How to fix the “The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) node. “ error

During creation the Availability group in SQL 2014, I have encounter the below error when try to add the 2nd replica.  

The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) node. (Microsoft.SqlServer.Management.HadrTasks)

image_thumb[11]

The local node is not part of quorum and is therefore unable to process this operation. This may be due to one of the following reasons:

•   The local node is not able to communicate with the WSFC cluster.

•   No quorum set across the WSFC cluster.

image_thumb[12]

This prompt me that maybe the 2nd instance does not know itself its HADR enable. So I qery sys.dm_hadr_cluster_members and sys.dm_hadr_cluster for both nodes.

On node1, it does return correct information. On node2, the result is empty.

SELECT *
FROM sys.dm_hadr_cluster_members;
 
Go
select * from sys.dm_hadr_cluster

image

The way to fix it is disable the HADR from SQL Server configuration manager . Bounce SQL Server and SQL agent. Rentable HADR and bounce SQL server and SQL agent.

The issue was resolved after 2nd bounce. 

image

27 comments:

  1. Excellent solution. It worked Thanks

    ReplyDelete
  2. Definitely a solution that I would want to give a try! This will definitely give sql students via Evolutionwriters.com rating some push and inspiration to pursue their passion and career in sql.

    ReplyDelete
  3. Thanks for sharing the useful information about the oracle topics and reading Best points were started in the blog for more information visit.
    Oracle fusion financials training

    ReplyDelete
  4. I am very happy because I can get very wonderful information, I wish you to always update other interesting information in accordance with this, Thank you very much for being willing to share this information with us.Please takes helps from authorized services that are available on web. Visit best essay writing service if you want more writing tips and guidelines.Visit custom essay writing service

    ReplyDelete
  5. When I initially commented, I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several emails with the same comment. Is there any way you can remove people from that service? Thanks.

    AWS Training in Bangalore | Amazon Web Services Training in Bangalore

    Amazon Web Services Training in Pune | Best AWS Training in Pune

    AWS Online Training | Online AWS Certification Course - Gangboard

    ReplyDelete
  6. Your very own commitment to getting the message throughout came to be rather powerful and have consistently enabled employees just like me to arrive at their desired goals.
    python online training
    python training in OMR
    python training course in chennai

    ReplyDelete
  7. This is a nice article here with some useful tips for those who are not used-to comment that frequently. Thanks for this helpful information I agree with all points you have given to us. I will follow all of them.
    Devops training in sholinganallur
    Devops training in velachery
    Devops training in annanagar
    Devops training in tambaram

    ReplyDelete
  8. myTectra Placement Portal is a Web based portal brings Potentials Employers and myTectra Candidates on a common platform for placement assistance

    ReplyDelete

  9. Amazon has a simple web services interface that you can use to store and retrieve any amount of data, at any time, from anywhere on the web. Amazon Web Services (AWS) is a secure cloud services platform, offering compute power, database storage, content delivery and other functionality to help businesses scale and grow.For more information visit aws online training

    ReplyDelete
  10. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.. 

    best rpa training in chennai | rpa online training |
    rpa training in chennai |
    rpa training in bangalore
    rpa training in pune
    rpa training in marathahalli
    rpa training in btm

    ReplyDelete
  11. The original Nintendo version involves the battle between the different Pokemon characters. Players act as trainers that lead their pets into the battle. The better trainer wins the game.EarnHoney

    ReplyDelete
  12. This comment has been removed by the author.

    ReplyDelete
  13. Thankyou for providing the information, I am looking forward for more number of updates from you thank you
    Machine learning training in chennai
    python machine learning training in chennai

    ReplyDelete
  14. Great post! I am actually getting ready to across this information, It's very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.Trending Software Technologies in 2018 | Hadoop Training in Chennai | big data Hadoop training and certification in Chennai

    ReplyDelete

  15. If you're buying a video game from a genre that you're unfamiliar with, it's important to develop an overall idea of the level of complexity involved in the game. Many niche games are made with the hardcore enthusiast in mind, and it can be difficult for a newcomer to enjoy them. Read reviews and product descriptions carefully to make sure you're ready for what you're getting into. Macgic.net

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates