Creating an ArcSDE service from a remote Windows server

If your database management system (DBMS) is installed on one server and ArcSDE is installed on a separate Windows server, you cannot run the ArcSDE Post Installation wizard to create the service. Instead, you must create the ArcSDE service manually. A manual setup on a Windows server is similar to how you set up on a Linux server: you must add entries to the ArcSDE and operating system services files, start the service using the sdemon command, and, for some database management systems, you must set environment variables. The main difference when setting up a service manually on a Windows server is you must use the sdeservice command to create the service.

The sdeservice command has the following syntax when used to create a service from a remote Windows computer:

sdeservice -o create -p <ArcSDE_admin_password> 
-n [-H <sde_directory>] [-i <service>] [-s <data_source>]
-d {ORACLE | SQLSERVER,SQLSERVERINSTANCE | DB2,DB2INSTANCE
| INFORMIX | POSTGRESQL,PGINSTANCE}
[-u <service_user>] [-P <service_user_password>]

When you create a service, the sdesetup command requires you to include the -d option and value. However, it is not possible for a Windows service to have a dependency on a service that is on a remote server. Therefore, you must specify the -n option to negate the dependency.

This command is only used on Windows servers and is executed at an MS-DOS command prompt. For more information about the sdeservice command, see the ArcSDE Administration Command Reference provided with the ArcSDE component of ArcGIS Server at the enterprise level.

Steps:

1. Add an entry for the service to the ArcSDE and operating system services file on the ArcSDE server.

   The ArcSDE services file (services.sde) can be found in the %SDEHOME%\etc folder. The service name and port number must be unique, so be sure there is not an existing entry in either services file that uses the same name or port number.

   There is a default entry in the services.sde that you can uncomment and use, or you can create your own entry. Add the same information to the services.sde file and operating system services file. For example:

   sdesvc      5151/tcp     # ArcSDE service on myserver

2. At an MS-DOS command prompt, type the sdeservice command with the create operation.

   sdeservice -o create -p sdepasswd -d SQLSERVER,BORIS\SSTHREE
   -n -i sdesvc

3. Register the database to use with the service.

   sdeservice -o register -r ADMIN_DATABASE -v ENTGDB
   -p sdepasswd -i sdesvc
   

4. Type the sdeservice command with the register operation to register the user with which the giomgr connects to the database.

   sdeservice -o register -d SQLSERVER,MYSERVER\SSINSTANCE 
   -r SDE_DBA_USER -v sa -i sdesvc

Once the service has been created, use the sdemon command to start it.