English

Error: Cannot open socket for listening, -102

Error Message

In ArcSDE 9.3 for SQL Server, when starting an ArcSDE service, the following error displays:

"Cannot open socket for listening, -102"

Cause

The ArcSDE service name and port number pairs are inconsistent between the
%SDEHOME\etc services.sde and the C:\WINDOWS\SYSTEM32\DRIVERS\ETC\service.

Solution or Workaround

Compare the ArcSDE service entries in the
%SDEHOME%\etc services.sde file and ArcSDE service entries in the C:\WINDOWS\SYSTEM32\DRIVERS\ETC\services file to make sure they are consistent.

  1. Open the %SDEHOME%\etc\services.sde file.
    For example:
    C:\Program Files\ArcGIS\ArcSDE\sqlexe\etc\services.sde
    Code:
    /* $Id: services.sde,v 1.2 1999/01/22 01:01:35 donna Exp $ */
    #
    # ESRI SDE Remote Protocol
    # Note: uncomment the line below to use ESRI's default port
    #
    esri_sde 5151/tcp
    #

  2. Open C:\WINDOWS\SYSTEM32\DRIVERS\ETC\service file.

    For example:
    Code:
    # Copyright (c) 1993-1999 Microsoft Corp.
    #
    # This file contains port numbers for well-known services defined by IANA
    #
    # Format:
    #
    # <service name> <port number>/<protocol> [aliases...] [#<comment>]
    #

    echo 7/tcp
    echo 7/udp
    discard 9/tcp sink null
    discard 9/udp sink null
    systat 11/tcp users #Active users
    systat 11/tcp users #Active users
    knetd 2053/tcp #Kerberos de-multiplexor
    man 9535/tcp #Remote Man Server
    ...
    ...
    ...
    esri_sde 5151/tcp #ArcSDE for SQL Server

    Make sure the ArcSDE service entry in the two files has the same service name and port number, in this case 'esri_sde' and '5151/tcp'.