English

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

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.