I have one Load Balancer with a frontend IP and twoo servers with SQL Always ON in backend.
The IP from front end are in both servers and I can not failover SQL.
Can some help me about this failover? I want to the IP of frontend need to be on the server that have the SQL, the primary server.