English

How To: Delete an ArcSDE service in Windows

Summary

ArcSDE service can be created both manually and via the Post Installation Wizard's user interface. In order to delete a service, the ArcSDE commands must be used as there is no user interface.

Note:
The ArcSDE command reference can be accessed by navigating to Start > Programs > ArcGIS > ArcSDE > Command references, and then select Administrative Commands > Alphabetical Listing of Commands > sdeservice.

Procedure

Verify that the service is stopped and gather all connection information about the service before deleting it.

Note:
It is recommended to create complete backup of the registry before making the following changes. See the link in the Related Information section for more information on where to look for orphaned SDE service keys.

  1. Run the following command to gather information about services that are currently running:
    It is important to note the service name and if it is currently running.

    Code:
    sdeservice -o list

    SDE service Information
    ----------------------------------------------------
    RDBMS: Oracle
    Name: ArcSde Service(oracle)
    SDEHOME: C:\ArcGIS\ArcSDE\ora9iexe
    Version: 9.1.0
    Status: SERVICE_STOPPED

    RDBMS: SQLServer
    Name: ArcSde Service(europe)
    SDEHOME: C:\ArcGIS\ArcSDE\sqlexe
    Datasource: NARLEY
    Admin_database: europe
    Version: 9.1.0
    Status: SERVICE_STOPPED

  2. If the service is currently running, use one of the following methods to stop the service:

    A. Run the following command:

    Code:
    sdemon -o shutdown -i <service_name> -p <sde password>

    or

    Code:
    net stop <service_name>

    B. Stop the service from the Windows services panel.
  3. Run the following command to delete the ArcSDE service from the Windows Registry:

    Code:
    sdeservice -o delete -i <service_name>


    Note:
    Be careful to use the -i <service_name> parameter if there is more than one ArcSDE service. If the service name parameter is not specified, it will delete all ArcSDE services.
  4. Manual edit the service files. These files are located at following default locations, however, the location may vary depending on Operating system, DBMS, and ArcSDE location:

    ArcSDE for SQL server
    C:\ArcGIS\ArcSDE\sqlexe\etc\services.sde

    ArcSDE for Oracle
    C:\ArcGIS\ArcSDE\sqlexe\etc\services.sde

    Windows OS services file:
    C:\WINNT\system32\drivers\etc\services
  5. If the service gets orphaned or corrupt and is partially still in the Windows registry, do one of the following:
    · Use a different service name. The same port number may be used.
    · Manually edit the registry to remove these entries.

Related Information