I faced unusual behavior associated with automatic failover so that automatic failover does not work in the case of turning off SQL Server service. It seems that clustered disks are still remaining attached to the failed node, but I cannot find out the final issue that causes this behavior. I will be very thankful to you if you can help me understand this issue.
For testing purposes, I have created iSCSI target on Domain Controller with 2 initiators connected to it:
Here are details about my cluster:
Here are details about my SQL Server service:
Here are details about clustered disks (I have only added details for one of the disk because two disks are identical):
Now, when I turn off SQL Server service, automatic failover of services does not occur:
I tested other scenarios where automatic failover successfully works:
- Manual failover
- Shutting down active node
- Disabling adapter on active node
- killing sql server process in task manager
- killing sql agent service process in task manager
In all above scenarios, resources successfully failed over to another node.
Could you please help me to figure out what is going wrong with automatic failover when I shutdown SQL Server service on active node?