Register now or log in to join your professional community.
In two SQL Server nodes, one of the node will always active and another one is passive is called clustur environment.
The failover cluster is required for high availability of database server. When active node not respond the passive one will be active.