Problem: Unable to use an ArcSDE server's IP address when adding a map service in Administrator
Using ArcIMS Author, an ArcSDE server can be connected to using the IP address and add the data to the AXL map configuration file. However, ArcIMS Administrator returns an error when attempting to add a service based upon this file.
"ArcIMS Service <service name> can not be created.
Check your map file's layers and data source connections."
The ArcIMS Author application uses the Java API to connect to SDE; the ArcIMS Spatial Server uses the C API to connect. The Java API can handle raw IP addresses, the C API cannot and instead uses the function gethostbyaddr() which uses the default name services ordering, that is, it queries DNS/BIND, NIS, then the local /etc/hosts file. The results of the nslookup indicate that the IP address cannot resolve to a host name.
Solution or Workaround
Use hostnames if possible but if the IP address must be used to connect, perform either of the following steps:
Add the ArcSDE server's IP address to the /etc/hosts file on the ArcIMS Server.
1. Open the file: C:\WINNT\system32\drivers\etc\hosts in a text editor.
2. Examine the format of the file and add the IP address of the ArcSDE server to the end of the file and save.
# Copyright (c) 1993-1999 Microsoft Corp.
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
# For example:
# 188.8.131.52 rhino.acme.com # source server
# 184.108.40.206 x.acme.com # x client host
220.127.116.11 esri.com #ArcIMS Server
18.104.22.168 sde.com #ArcSDE Server
Set the SDENOIPTEST environment variable to 'True', it can be any value but 'True' is appropriate. The ArcIMS daemons need to be restarted after the variable is set.
The SDENOIPTEST variable does not work on Windows platforms.