By default, clients connect to the port listed in the query line of the server entry. If that port is not available (because that server has failed-over), the client connects to the server listed in the hafailover line of the server entry in sql.ini. Here is a sample sql.ini file for a primary companion named MONEY1 and a secondary companion named PERSONNEL1:
[MONEY1] query=TCP,FN1,9835 master=TCP,FN1,9835 hafailover=PERSONNEL1 [PERSONNEL1] query=TCP,HUM1,7586 master=TCP,HUM1,7586 hafailover=MONEY1
Use dsedit to add entries to the sql.ini file. If sql.ini entries already exist, modify them to work for fail over.
