The system environment:
Three Windows server 2012 server do WSFC, arbitration mode, using multiple nodes without arbitration disk;
3 servers deployed three respectively used to 2012 examples, do alwayson cluster,

Normal operation for 2 years, because of the sudden network failure WSFC one node fails,

The process is as follows:
1. Try out in WSFC fault nodes and add again, failure,
2. Change alwayson cluster parsing IP monitoring, make its point directly to the master node cluster,
3. Remove the alwayson and WSFC cluster, redo WSFC cluster fails,
4. Reinstall the function of fault node WSFC, redo WSFC clusters success,
5. The master node in the original cluster redo alwayson usability group times wrong,

An error is as follows:


WSFC state is normal, is as follows:




Alwayson configuration:


Which master had encountered similar problems, or give me a way of thinking,

CodePudding user response:

In other nodes do alwayson group to see if can success?

CodePudding user response:

reference 1st floor yenange response:

change alwayson group to see if other nodes do to success?

Now only OADB02 create usability group node can open interface, the other nodes connected times wrong:

CodePudding user response:

To look at the first close all firewalls, see if I can make it successful

CodePudding user response:

Ask next operations staff, have done what operation?

CodePudding user response:

reference yenange reply: 3/f

see first shut down all firewalls, can see success

Try to pass the firewall and restart the database instance and restart the server are tried,
I think the core of the problem is that the server on the local instance, even create usability group does not open, the interface of feeling while success enabled alwayson configuration, but did not identify the WSFC cluster instance,

reference 4 floor yenange response:

ask next operations staff, for any operation?

I am the ops, only I have access to these servers,

CodePudding user response:

A few machines still in not in the domain?
How much is the SQL Server version?
Select @ @ version

Do you have any questions to visit each other between several machine?

CodePudding user response:

1. A server restart after the installation is complete? If not restart the
2. Look at the cluster events if there is any mistake

CodePudding user response:

refer to 6th floor yenange response:

several machine is now in is not in the domain?
How much is the SQL Server version?
Do you have any questions to visit each other between several machine?

1. In the domain,
2. Three nodes version, is as follows:
Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19, 2012 13:38:57
Copyright (c) Microsoft Corporation
Enterprise Edition (64 - bit) on Windows NT 6.2 & lt; X64 & gt; : (Build 9200) (Hypervisor)
3. Three node can access the database instance,

CodePudding user response:

The

reference 7 floor z10843087 response:

1. The server restart after the installation is complete? If not restart the
2. Look at the cluster events have error

1. Reboot,
2. No any error in WSFC,

CodePudding user response:

refer to the eighth floor malavon response:

Quote: refer to the sixth floor yenange response:

A few machines still in not in the domain?
How much is the SQL Server version?
Do you have any questions to visit each other between several machine?

1. In the domain,
2. Three nodes version, is as follows:
Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19, 2012 13:38:57
Copyright (c) Microsoft Corporation
Enterprise Edition (64 - bit) on Windows NT 6.2 & lt; X64 & gt; : (Build 9200) (Hypervisor)
3. Three node can access the database instance,

I'm not talking about each other to access the database instance, is a mutual ping the domain name if you have any questions?
Ping xxx.xxx.com

CodePudding user response:

references to the tenth floor yenange response:

Quote: refer to the eighth floor malavon response:

Quote: refer to the sixth floor yenange response:

A few machines still in not in the domain?
How much is the SQL Server version?
Do you have any questions to visit each other between several machine?

1. In the domain,
2. Three nodes version, is as follows:
Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19, 2012 13:38:57
Copyright (c) Microsoft Corporation
Enterprise Edition (64 - bit) on Windows NT 6.2 & lt; X64 & gt; : (Build 9200) (Hypervisor)
3. Three node can access the database instance,

I'm not talking about each other to access the database instance, is a mutual ping the domain name if you have any questions?
Ping xxx.xxx.com

Ping each other no problem,
Touch point for, wait to test the outage window,

CodePudding user response:

11 references malavon response:

Quote: reference to the tenth floor yenange response:

Quote: refer to the eighth floor malavon response:

Quote: refer to the sixth floor yenange response:

A few machines still in not in the domain?
How much is the SQL Server version?
Do you have any questions to visit each other between several machine?

1. In the domain,
2. Three nodes version, is as follows:
Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19, 2012 13:38:57
Copyright (c) Microsoft Corporation
Enterprise Edition (64 - bit) on Windows NT 6.2 & lt; X64 & gt; : (Build 9200) (Hypervisor)
3. Three node can access the database instance,

I'm not talking about each other to access the database instance, is a mutual ping the domain name if you have any questions?
nullnullnullnullnullnullnullnullnullnull