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]](http://lh3.ggpht.com/-Pnh7toBdTyk/VEgv9_b7LfI/AAAAAAAAMWI/soPX4APejiA/s1600-h/image_thumb%25255B11%25255D%25255B2%25255D.png "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]](http://lh3.ggpht.com/-16-7aJRbTx0/VEgv-yvPwBI/AAAAAAAAMWU/_i_Sn7c_p3k/s1600-h/image_thumb%25255B12%25255D%25255B2%25255D.png "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
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.
Excellent solution. It worked Thanks
ReplyDeleteDefinitely 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.
ReplyDeleteThanks for sharing the useful information about the oracle topics and reading Best points were started in the blog for more information visit.
ReplyDeleteOracle fusion financials training