English

How To: Change the SDE user password for an ArcSDE service

Summary

Instruction provided describe how to change the SDE user password for an ArcSDE Service. Use this method, for example, when the password needs to be changed for security purposes or when the SDE user/login password is changed in the database but not in the registry setting for the service.

Note:
These steps only apply to Windows, as Unix operating systems does not have the concept of services.

Procedure

When changing the SDE user password for an ArcSDE service, change the SDE user/login password in the database as well as what is set in the Windows Registry for the service (under the SDE_DBA_PASSWORD key). Since this information is encrypted in the Windows Registry, the ArcSDE command line utilities must be used to modify the service.

  1. Make the changes in the database for SDE users password first and then proceed to modifying the service using the ArcSDE command line tools. Start and/or stop the service with the command line tools when modifying the password information.
  2. Start an MS-DOS command prompt and type sdeservice -o modify to get the following syntax:

    Code:
    ---------------------------------------------------------------
    ESRI ArcSDE System Service Utility Wed Aug 23 10:20:52 2006
    ---------------------------------------------------------------
    sdeservice -o modify -r <registry_keyword> -v <new_value>
    -d <ORACLE8I|ORACLE9I|ORACLE10G|SQLSERVER|DB2|INFORMIX|COVERAGES>
    -p <SDE_DBA_Password> [-i <service>]

  3. Use this as a guideline to execute the command and modify the SDE_DBA_PASSWORD setting for the service. The following is an example of this command to modify the SDE password for ArcSDE 9.1 on SQL Server 2000:

    Code:
    >sdeservice -o modify -r SDE_DBA_PASSWORD -v NEW_PASSWORD -d SQLSERVER -p OLD_PASSWORD -i esri_sde


    Note:
    If the old SDE user/login password is not known, change the password for the service by deleting and recreating the ArcSDE service. See the link in the Related Information section for more information on how to delete an ArcSDE service in Windows.

  4. Shutdown and restart the ArcSDE service to ensure that there are no problems with the service start up process from changes made in the database and service properties in the Windows Registry.

Related Information