New to failover and clustering, but got a question -
If there are two SQL servers- SQL01 and SQL02, with alwayson set up for failover. If/When the first server dies, how do clients connect to the second? If an application is pointed to an ODBC connection that's pointing to SQL01, if that server goes down, although it's now running on SQL02, what's the procedure to have the client connections automatically point to the new server?
Again, please excuse the ignorance