English

How To: Create a spatial database connection from a PC on one subnetwork or network to a database on a different subnetwork or network

Summary

When making a database connection in ArcCatalog from a computer that is not on the same subnetwork or network as the server where the ArcSDE geodatabase and/or ArcSDE service resides, the connection fails because it cannot find the server based on the server name.

Instructions provided describe how to provide the IP address of the server to make the connection.

Procedure

Connect to the geodatabase using either a direct connection or an ArcSDE service.

  • If making a direct connection to the geodatabase, specify the IP address of the server, on which the ArcSDE geodatabase resides, in the Service field of the Spatial Database Connection dialog box.
    1. In the ArcCatalog tree, double-click 'Add Spatial Database Connection;'.
    2. Type the IP address of the server, on which the geodatabase resides, in the Server field.
    3. In the Service field, use the direct connection syntax to specify the location of the geodatabase, but use the IP address of the server rather than the name of the server. For example:
      sde:sqlserver:123.61.1.1
    4. Type the name of the geodatabase in the Database field, unless the geodatabase is stored in Oracle. For Oracle, a database name does not need to be specified.
    5. Check either Database Authentication and provide a database user name and password, or check Operating system authentication.
    6. If necessary, change the version of the geodatabase that is being connected to by clicking Change in the Connection Details section.
    7. Click Test Connection to be sure the connection succeeds, then click OK.

      If the connection does not succeed, double-check the entries for the previous steps. If the entries are correct and a connection can still not be made, contact the database administrator to be sure the database is running and available for connections.
  • If using an ArcSDE service, specify the name and IP address of the ArcSDE server in the system's host file of the connecting computer.
  1. Start Windows Explorer on the connecting computer.
  2. Navigate to the system's host file. If using Windows XP or Windows 2003, that file is located at: C:\WINDOWS\system32\drivers\etc

    On Windows 2000, that file is located at: C:\winnt\system32\drivers\etc
  3. Open the hosts file using Notepad.
  4. Add an entry at the bottom of the host file for the ArcSDE server. Include the IP address, server name, and a comment to indicate what the host is. For example:
    107.45.92.25 sinope.jupiter.universe.com #ArcSDE server sinope on subnet Jupiter
  5. Save and close the host file.
  6. Open ArcCatalog and double-click Add a Spatial Database Connection.
  7. Type the name of the server in the Server field. Be sure the server name matches what was typed in the host file. In the example above, type in sinope.jupiter.universe.com.
  8. Type the name of the service in the Service field.
  9. Type the name of the geodatabase in the Database field unless the geodatabase is stored in Oracle. For Oracle, a database name does not need to be specified.
  10. Check either Database Authentication and provide a database user name and password, or check Operating system authentication.
  11. If necessary, change the version of the geodatabase that is being connected to by clicking Change in the Connection Details section.
  12. Click Test Connection to be sure the connection succeeds, then click OK.

    If the connection does not succeed, double-check the entries for the previous steps. If the entries are correct and a connection can still not be made, contact the database administrator to be sure the database is running and available for connections.