Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Friday, February 7, 2020 3:47 PM
Hi everyone, I have two servers joined to a domain and I need to install a sql server database failover cluster. Both servers have already installed the figure of failover clustering and the network cards are grouped in NIC Teaming with a Teaming Mode "Switch Independent" and Load Balancing "Dynamic". The problem is that when I want to create the cluster using the wizard, I add the first node without problems, however, when adding the second node I have the following error: "The node cannot be contacted. Ensure that node is powered on and is connected to the network ". Am I missing something? Please I need help about it.
All replies (3)
Saturday, February 8, 2020 2:58 PM ✅Answered
Run the cluster validation wizard on the configuration before you try to create the cluster. The validation wizard does an excellent job of identifying any potential configuration problems.
Also, as this is a cluster for SQL purposes, you may want to ask the SQL HA experts in their forum -
https://social.technet.microsoft.com/Forums/en-US/home?forum=sqldisasterrecovery
SQL has some other methods to ensure high availability, and though clustering has long been the route, it is not always the best solution. The experts in the SQL HA forum would be better able to assist you in defining the best solution for you.
tim
Monday, February 10, 2020 3:02 AM ✅Answered
Hi,
1. Please run Cluster validation and make sure no error in its report, you can also upload your report if you cannot understand it.
2. Please try to disable firewall on both node and check the result.
3. As Tim's suggestion, you should better discuss with SQL HA experts over there.
https://social.technet.microsoft.com/Forums/en-US/home?forum=sqldisasterrecovery
Here is a similar post for your reference:
For more information please refer to following MS articles:
Network infrastructure and domain account requirements for a failover cluster
http://technet.microsoft.com/en-us/library/cc771404.aspx#BKMK_Account_Infrastructure
Understanding Cluster Validation Tests: Network
http://technet.microsoft.com/en-us/library/cc771323(v=ws.10).aspx
Firewall exceptions not honored after cluster failover
http://support.microsoft.com/kb/2568645
Hope this can help you.
Best Regards,
Daniel
Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact
Wednesday, February 12, 2020 6:10 AM
Hi,
I am writing here to confirm current situation.
If the above suggestion are helpful to you, please be kind enough to "mark it as an answer" for helping more people.
Regards,
Daniel
Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact