Can Quick Connect be setup to failover to a secondary Quick Connect service to achieve fault tolerance
At this time, Quick Connect cannot dynamically failover to a secondary instance in the event of a server failure. Enhancement Request TF0198401 has been submitted for consideration in future versions.
Quick Connect can be installed on two separate servers for failover. But the failover is a manual process, it is not dynamic.
To set this up please review the following steps:
1.Install two instances and connect them to the same SQL server or SQL cluster.
2. Stop the second Quick Connect service
3. In the event of a failover, you need to go start that service on the 2nd server manually