SQLTeam.com | Weblogs | Forums

How To preform an Automatically FailOver between Nodes in SQL SERVER

tsql
sql2014
availability-groups

#1

Hi,

I have SQL Server 2014 running on Windows Server 2012 R2.
I want to perform an Automatically Failover between two nodes.

There are two nodes, with Automatic Failover and Synchronized Mode.Cluster is using file share witness on remote server.

I shut Down the primary SQL Server service from the configuration manager in order to preform the automatically failOver to the second Node, and hoped that will be an Automatically failOver between the Nodes, but it's not happened.

Results: the AG waits on Resolving state.

NOTE; if i preformed Manual FailOver from the SSMS Wizard, it OK

Now, i have telnet between the nodes on ports 5022 and 1433.

Please Advise
S


#2

check this out, hope it helps:
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-group-is-not-ready-for-automatic-failover