Setting up multiple ArcSDE services on one Windows server

If you have two separate geodatabases on the same server and are using an ArcSDE service, you must have separate ArcSDE services with unique service names and a separate port number in the services files.

The following steps assume you have already created the second geodatabase:

Steps:
  1. Open the services.sde file and the Windows services file and add an entry for your new service.

    For example, if your new service is sde2 on port 9999, add this entry to both files:

    sde2					9999/tcp

  2. Use the sdeservice command with the create operation to create a service. You will be prompted to provide the password for the database administrator.

    The following example shows creating a service when ArcSDE and the database are installed on the same server. For syntax to use with the create operation when ArcSDE and the database are on separate servers, see Creating an ArcSDE service from a remote Windows server.

    In this example, a service is created for a geodatabase in a named SQL Server instance (tundra\projects).

    sdeservice -o create -d SQLSERVER,tundra\projects -i sde2
    

    TipTip:

    For more information on the sdeservice and sdemon commands, see the ArcSDE application server installation guide provided with your download or installation media.

  3. Use the sdeservice command with the register operation to register the second geodatabase with the new service.

    In this example, the gdb2 geodatabase is registered with the sde2 service.

    sdeservice -o register -d SQLSERVER -r ADMIN_DATABASE -v gdb2 -i sde2
    
  4. Use the sdeservice command with the register operation to register the geodatabase administrator user.
    sdeservice -o register -d SQLSERVER,MYSERVER\SSINSTANCE 
    -r ADMIN_DATABASE -v mygdb
    
  5. Use the sdemon command with the start operation to start the new service.

    sdemon -o start -i sde2
    

    To start a service on a remote computer, see Starting a remote ArcSDE service on Windows.

11/14/2016