Can you explain what happens in this situation.
Imagine I have a Sql Server Mirroring set-up with 2 databases and 1 witness.
Database clients have in their ConnectionStrings the Principal= and Failover=.
Now imagine if the clients can't connect to Principal for some reason (e.g. Network error) but can for the Failover.
Will they automatically try the failover? What happens from the SQL Server perspective. What happens from the clients perspective?