Creating an ArcSDE service on Windows using the sdeservice command

You can create and register an ArcSDE service on Windows servers using the ArcSDE for SQL Server Post Installation wizard. However, you can also create a service from an MS-DOS prompt using the sdeservice command. That process is described in this topic.

You must first execute the sdeservice command with the create operation, then execute the sdeservice command with the register operation to specify to which database this new service will be used.

Syntax to execute this against a geodatabase in SQL Server is as follows:

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

sdeservice -o register -d SQLSERVER,SQLSERVERINSTANCE -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 component of ArcGIS Server at the Enterprise level.

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.

   sdeservice -o create -d SQLSERVER,MYSERVER\SSINSTANCE -i sdesvc -p keepout 

   Note:

   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 to register the service with a specific geodatabase.

   sdeservice -o register -d SQLSERVER,MYSERVER\SSINSTANCE -r ADMIN_DATABASE 
   -v mygdb -i sdesvc

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

4. If your geodatabase is stored in the dbo schema, type the sdeservice command with the register operation again to register the user with which the giomgr will connect to the geodatabase.

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

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