Using Multiple TCP/IP Network Interface Cards

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