Creating an ArcSDE service on Windows using the sdeservice command

You can create and register an ArcSDE service on Windows servers from an MS-DOS prompt using the sdeservice command.

Tip:

The sdeservice command is installed with the ArcSDE application server.

You must first execute the sdeservice command with the create operation. On all databases except Oracle, execute the sdeservice command again with the register operation to specify with which database this new service will be used.

The syntax to execute this against a geodatabase in PostgreSQL is as follows:

sdeservice -o create -d POSTGRESQL,PGINSTANCE -i <service> –p <ArcSDE_admin_password> 
[–n] [–H <sde_directory>] [–u <service_user>] [–P <service_user_password>] 
[–s <data_source>]

sdeservice -o register -d POSTGRESQL,PGINSTANCE -r ADMIN_DATABASE 
-v <registry_value> -i <service> -p <ArcSDE_admin_password>

The contents in brackets ([ ]) are optional depending on your situation. For more information on using the sdeservice command, see the sdeservice command topic in the Administration Command Reference provided with the ArcSDE application server installation.

Steps:

1. Open an MS-DOS command prompt window on a computer from which you have access to the ArcSDE commands.
2. Type the sdeservice command with the create operation.

   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.

   sdeservice -o create -d POSTGRESQL,postgresql-x64-9.0 
   -i sdesvc -p nomira -s myserver
   

   If you do not specify a name with the –i option, the default name of esri_sde is used.

3. Type the sdeservice command with the register operation.

   sdeservice -o register -d POSTGRESQL,postgresql-x64-9.0 
   -r ADMIN_DATABASE -v mygdb -i sdesvc -p nomira
   

   This creates an ADMIN_DATABASE value in the registry for the service.