Error Message

While running Direct Connect to a Microsoft SQL Server database the follwing error is returned in the ArcIMS Administrator message console:


Adding Service...
> Mar 31, 2004 4:53:31 PM: com.esri.mo.client.io.EsrimapInputStream
SDE connection is broken (ganges:sde:sqlserver) NETWORK I/O OPERATION FAILED.
ImageServer: Layer DATA.GISDBA.MYWORLD cannot be created. Unable to establish connection with datasource.

at com.esri.mo.client.io.EsrimapInputStream.a(Unknown Source)

at com.esri.mo.client.io.EsrimapInputStream.read(Unknown Source)

at java.io.DataInputStream.read(Unknown Source)

at com.esri.mo.client.io.a.fill(Unknown Source)

at com.esri.mo.client.io.a.read(Unknown Source)

at java.io.BufferedReader.fill(Unknown Source)

at java.io.BufferedReader.readLine(Unknown Source)

at java.io.BufferedReader.readLine(Unknown Source)

at com.esri.mo.client.io.EsrimapSecureInputStream.a(Unknown Source)

at com.esri.mo.client.io.EsrimapSecureInputStream.available(Unknown Source)

at java.io.BufferedInputStream.available(Unknown Source)

at com.esri.aims.admincore.xml.nb.a(Unknown Source)

at com.esri.aims.admincore.xml.nb.c(Unknown Source)

at com.esri.aims.admincore.site.Service.addService(Unknown Source)

at com.esri.aims.admincore.site.c.a(Unknown Source)

at com.esri.aims.admin.managers.s.a(Unknown Source)

at com.esri.aims.admin.managers.nb.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

> Mar 31, 2004 4:53:31 PM: java.lang.String
<?xml version="1.0"?><ERRORS><ERROR message="Error When trying to administer Service."/><ERROR message="ArcIMS Service dc cannot be created. Check your map file's layers and data source connections." /></ERRORS>


Attempting run a Direct Connect through ArcIMS to a Microsoft SQL Server database requires the Microsoft SQL Server datasource name in the AXL file as a addendeum to the instance name. In other words, the Microsoft SQL Server datasource name should be appended to the instance name in the AXL file. If the correct instance name is not provided in the AXL file, the error listed above is returned in ArcIMS Administrator.

Solution or Workaround

  1. Add the correct datasource name. A default installation of Microsoft SQL Server will name the datasource as your machine name.

    Edit the AXL file and change the instance parameter for the SDEWORKSPACE tag and append the Microsoft SQL Server datasource name to the instance name. In this example, the machine name is "ganges". To find more about Microsoft SQL Server datasource name, please refer Microsoft SQL Server documentation.
    <SDEWORKSPACE name="sde_ws_0" server="ganges" instance="sde:sqlserver:ganges" database="data" user="" encrypted="" password="" geoindexdir="" />