When client workstations use multiple TCP/IP network interface cards, the Windows
administrator must edit the lmhosts file on the Windows server to
accept connections from clients.
When entering the card information:
-
There must be one entry for each network card.
-
Each address must be unique.
-
The entries in the lmhosts file match those in the
sql.ini file.
For example, assume that a server named BALCLUTHA has three
cards. Without an
lmhosts entry and separate
entries in
sql.ini, the server listens on socket
BALCLUTHA,5000 for all three cards. To provide unique addresses, set
up
lmhosts as follows:
130.214.10.248 NT0
130.214.11.248 NT1
130.214.12.248 NT2
In the
sql.ini file, add entries for
both QUERY and MASTER:
[BALCLUTHA]
query=NT0,5000
master=NT0,5000
query=NT1,5000
master=NT1,5000
query=NT2,5000
master=NT2,5000