HOW TO

Configure an SDE database connection so you are not prompted for login information

Last Published: April 25, 2020

Summary

This article illustrates how to bypass the username and password login each time you connect to an SDE database. The steps below assume you have prior experience logging in and working with SDE Connections. If you need help logging in, refer to the ArcGIS Help documentation.

Procedure



  1. Open ArcCatalog.
  2. Right-click on the SDE connection under Catalog > Database Connections and select Connection Properties.
  3. Ensure the "Save Name/Password" check box is checked.
    [O-Image] SDE database connections dialog box
    Note:
    ArcCatalog saves the username and password to an encrypted binary.

  4. Click on the Database Connections folder and select Refresh from the View menu. Refresh ArcCatalog with the SDE database connections closed.
    [O-Image] SDE database connection
  5. Search your computer for a file with the name. . .

    <username>@<database>.sde.

    This file will be located in the user's profile directory.
    [O-Image] Find File
  6. Copy this file to all users' profile directories you do not want to prompt for a login dialog when connecting to the SDE database.

Article ID:000004565

Software:
  • ArcMap 8 x
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic