In this blog post, let’s learn about the error message “19407 – The lease between availability group ‘%.*ls’ and the Windows Server Failover Cluster has expired. A connectivity issue occurred between the instance of SQL Server and the Windows Server Failover Cluster. To determine whether the availability group is failing over correctly, check the corresponding availability group resource in the Windows Server Failover Cluster.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
19407 – The lease between availability group ‘%.*ls’ and the Windows Server Failover Cluster has expired. A connectivity issue occurred between the instance of SQL Server and the Windows Server Failover Cluster. To determine whether the availability group is failing over correctly, check the corresponding availability group resource in the Windows Server Failover Cluster.
Reason for the Error
To be update soon…
Solution
To be update soon…