Wednesday, October 22, 2014

89 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

89 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
  16. nice work keep it up thanks for sharing the knowledge.Thanks for sharing this type of information, it is so useful.
    Epoxy Grout manufacturer in delhi

    ReplyDelete
  17. nice work keep it up thanks for sharing the knowledge.Thanks for sharing this type of information, it is so useful.
    Epoxy Grout manufacturer in delhi

    ReplyDelete
  18. Amazing article. Your blog helped me to improve myself in many ways thanks for sharing this kind of wonderful informative blogs in live. I have bookmarked more article from this website. Such a nice blog you are providing ! Kindly Visit Us @ Best Travels in Madurai | Tours and Travels in Madurai | Madurai Travels

    ReplyDelete
  19. Indoor LED Wall Lights in delhi
    Thanks for giving great kind of information. So useful and practical for me. Thanks for your excellent blog, nice work keep it up thanks for sharing the knowledge.

    ReplyDelete
  20. Really awesome blog. Your blog is really useful for me
    Regards,
    Data Science Course In Chennai

    ReplyDelete
  21. Hmm, it seems like your site ate my first comment (it was extremely long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog. I as well as an aspiring blog writer, but I’m still new to the whole thing. Do you have any recommendations for newbie blog writers? I’d appreciate it.
    Advanced AWS Training in Bangalore | Best Amazon Web Services Training Institute in Bangalore
    Advanced AWS Training Institute in Pune | Best Amazon Web Services Training Institute in Pune
    Advanced AWS Online Training Institute in india | Best Online AWS Certification Course in india
    AWS training in bangalore | Best aws training in bangalore

    ReplyDelete
  22. Wow it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. it is really explainable very well and i got more information from your blog.
    microsoft azure training in bangalore
    rpa training in velachery| rpa training in tambaram |rpa training in sholinganallur | rpa training in annanagar| rpa training in kalyannagar

    ReplyDelete
  23. Read all the information that i've given in above article. It'll give u the whole idea about it.
    Best Devops online Training
    Online DevOps Certification Course - Gangboard

    ReplyDelete
  24. Thanks for giving great kind of information. So useful and practical for me. Thanks for your excellent blog, nice work keep it up thanks for sharing the knowledge.
    Modular Kitchen in Noida

    ReplyDelete
  25. Information from this blog is very useful for me, am very happy to read this blog Kindly visit us @ Luxury Watch Box | Shoe Box Manufacturer | Luxury Cosmetics Box

    ReplyDelete
  26. Thank you for allowing me to read it, welcome to the next in a recent article. And thanks for sharing the nice article, keep posting or updating news article.
    python Course in Pune
    python Course institute in Chennai
    python Training institute in Bangalore

    ReplyDelete

  27. This is really impressive post, I am inspired with your post, do post more blogs like this, I am waiting for your blogs.


    Data Science Course in Chennai

    Data Science With R

    Python Training in Chennai

    Machine Learning in Chennai

    SAS Training in Chennai

    ReplyDelete
  28. Hey, would you mind if I share your blog with my twitter group? There’s a lot of folks that I think would enjoy your content. Please let me know. Thank you.
    AWS Training in Chennai
    Data Science Training in Chennai

    ReplyDelete
  29. 1st news web site this site provide a news information so more gain information. 1st news

    ReplyDelete
  30. Nice article i have ever read information's like this.it's really awesome the way you have delivered your ideas.i hope you will add more content in your blog.
    Software Testing training in Chennai | Software Testing training in Chennai

    ReplyDelete
  31. I feel happy about and learning more about this topic. keep sharing your information regularly for my future reference. This content creates new hope and inspiration within me. Thanks for sharing an article like this. the information which you have provided is better than another blog.
    Best IELTS training centre in Dwarka Delhi

    ReplyDelete
  32. Very interesting blog. Alot of blogs I see these days don't really provide anything that I'm interested in, but I'm most definately interested in this one. Just thought that I would post and let you know. cloud hosting providers

    ReplyDelete
  33. Due to low budget most of the webmasters don't get the opportunity to enjoy the handling a dedicated server. minecraft server hosting

    ReplyDelete
  34. Amazing article. Your blog helped me to improve myself in many ways thanks for sharing this kind of wonderful informative blogs in live. I have bookmarked more article from this website. Such a nice blog you are providing ! Kindly Visit Us @ Best Travels in Madurai | Tours and Travels in Madurai | Madurai Travels

    ReplyDelete
  35. I'm really impressed about the info you provide in your articles. If you want to invest in suits and be stress-free, then you should shake hands with us. We are providing great clothing in the most reasonable price range that you wouldn’t find anywhere else. Put your trust in us as your supplier since we are the prominent printed stickers uk You can rely on us for the clothing problems we assure you we will never let our customers down.

    ReplyDelete
  36. Attend The Python training in bangalore From ExcelR. Practical Python training in bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Python training in bangalore.
    python training in bangalore

    ReplyDelete
  37. Home Mart is a site about Home Improvement, Furniture, Home Appliances and many more. We are a bunch of passionate group of people who aim to serve you a convenient one-stop online shopping experience, for you to be able to sit at home worry-free and pick your favorite products with value.

    Check out the best
    furniture nz
    furniture sale
    Dog Cages
    bedroom furniture nz
    entertainment unit
    shoe rack

    ReplyDelete
  38. Hi I am backlinks expert. i will provide high authority backlinks blog commenting,NICH blog commenting niche comment.

    ReplyDelete
  39. Wow, excellent post. I'd like to draft like this too - taking time and real hard work to make a great article. This post has encouraged me to write some posts that I am going to write soon
    Die Cut Bookmarks
    custom wig pillow boxes
    Custom Packaging Boxes

    ReplyDelete
  40. Great article! I enjoyed this movie and I thought the fight scenes are some of the best I’ve saw. I never thought this would be as good but I was wrong. I just watched it using my DISH online feature where I get thousands of movies I can watch and thought I would give this third movie a try
    Reflective Stickers
    custom hair extension boxes
    Custom Printed Boxes Uk
    Logo Stickers
    custom stickers uk

    ReplyDelete
  41. We are providing great Boxes in the most reasonable price range that you wouldn’t find anywhere else.Custom Box Printing
    custom burger boxes

    ReplyDelete
  42. Hey, would you mind if I share your blog with my twitter group? There’s a lot of folks that I think would enjoy your content. Please let me know. Thank you.
    Data Science Training in chennai | data science course in chennai | data science Training Institute in Chennai | data scientist course in chennai

    ReplyDelete
  43. I’m curious to find out what blog system you’re utilizing? I’m having some small security problems with my latest website and I’d like to find something more safe. Do you have any suggestions? And Bet Numbers

    ReplyDelete
  44. Usually I never comment on blogs but your article is so convincing that I never stop myself to say something about it. You’re doing a great job Man,Keep it up.
    Study in New Zealand Consultants in Delhi

    ReplyDelete
  45. Thanks for sharing an informative blog keep rocking bring more details.I like the helpful info you provide in your articles. I’ll bookmark your weblog and check again here regularly. I am quite sure I will learn much new stuff right here! Good luck for the next!
    mobile application development training online
    web designing course with placement in chennai
    web designing training institute in chennai
    web design and development training
    mobile app development course
    mobile application development course
    learn mobile application development
    mobile app development training

    ReplyDelete
  46. Hi,
    Good job & thank you very much for the new information, i learned something new. Very well written. It was sooo good to read and usefull to improve knowledge. Who want to learn this information most helpful. One who wanted to learn this technology IT employees will always suggest you take python training in pune. Because python course in pune is one of the best that one can do while choosing the course.

    ReplyDelete
  47. Really cool post, highly informative and professionally written and I am glad to be a visitor of this perfect blog, thank you for this rare info!thanks for your details it's very use for my works web design company in velachery

    ReplyDelete
  48. Attend The Analytics Training Institute From ExcelR. Practical Analytics Training Institute Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Analytics Training Institute.
    ExcelR Analytics Training Institute

    ReplyDelete
  49. If you visit other cities and you want to have awesome fun then please meet my friends who are hot and sexy meet these wild beauties for the pleasure you are seeking I assure you that these young women are incredibly sexy and passionate to the degree that you imagine your wildest fantasies will come true hurry up and call them you can know a little about them on this page and then you can choose which one to meet you must grab this opportunity of being with a fine woman with delicate features and romance them so that your life is cherished forever you can go to these towns to have these beauties Watch Series with you and enjoy your life to the fullest just go and book a hotel and then invite these girls to your room for some adventure.

    ReplyDelete
  50. As a privately owned company, Bachleor developer company ptv ltd provides IT Consultancy, software design and development as well as professional services and hardware deployment and maintenance to the following verticals: Government (Local and Central) Financial Services (insurance, banking and clearing house) Telecommunications.software company in latifabad #2

    ReplyDelete
  51. Nice information, thanks for sharing with us. Visit OGEN Infosystem for the best Website Designing Company and also get the SEO Services.
    Website Design Company

    ReplyDelete
  52. Awesome blog, thanks for sharing with us. Visit Sarswati Enterprises for Pilfer Proof Caps and Aluminum caps & Closure Machinery in your budget.
    Aluminum caps & Closure Machinery

    ReplyDelete
  53. Awesome blog, thanks for sharing with us. Visit Sarswati Enterprises for Pilfer Proof Caps and Aluminum caps & Closure Machinery in your budget.
    Aluminum caps & Closure Machinery

    ReplyDelete

 

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