User`s guide

SFVRA Connection Manager 23
S YSTEM I NSTALLATION
Installing the SFVRA Connection Manager System
9. For Server, select the device on which the SQL Server was installed.
Note: If the database is on a different IP subnet, steps 10 and 11 are necessary for configuration.
If the database is on the same subnet, skip to step 12.
10. Enter an IP address as the Network Address of the machine on which the database resides.
Note: The IP address of the machine on which the database resides may also be configured
in the LMHOSTS file or using WINS.
• LMHOSTS file configuration
Enter the IP address of the SQL Server with the server name in the
c:\winnt\system32\drivers\etc\LMHOSTS file. The entry shown below allows the
system to resolve a NetBIOS name to an IP address.
1.1.1.1 Server_Name
• WINS configuration
Register the SQL Server machine and the remote machine with the same WINS Server.
The remote machine must disable LMHOSTS checking in the WINS Server
configuration. The procedures for creating, configuring and maintaining a WINS
Server are beyond the scope of this document. Consult the Windows NT system
documentation for these procedures.
11. Enter
DBMSSOCN as the Network Library.
Note: The DBMSSOCN.DLL file may be obtained from the Microsoft SQL Server CD-ROM.
This file should be saved in the c:\winnt\system32 directory.
12. Click Options. Enter
SFVRA for the Database Name. Deselect Generate Stored Procedure for
Prepared Statement.