Add Entries to sql.ini for Client Connections During Failover

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 PERSONEL1:

[MONEY1]
query=TCP,FN1,9835
master=TCP,FN1,9835
hafailover=PERSONEL1
[PERSONEL1]
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, you must modify them to work for Failover.

See Installing Adaptive Server and OmniConnect for Windows NT for information about dsedit.