Password Encryption


This topic is retained to support regression to releases of Enterprise Architect prior to version 7.1. For password encryption for all repositories at and beyond release 7.1, see the Model Shortcuts topic.

Users of SQL Server or Oracle repositories have the option of encrypting the password used to set up the connection between Enterprise Architect and the repository.

The Enterprise Architect user does not have the real password, thereby preventing them from accessing the repository using other tools such as Query Analyzer or SQLPlus. Once security is enabled, the administrator must log on to access the dialog to create encrypted passwords.

To encrypt a password, follow the steps below:

  1. Select the Project | Security | Encrypt Password menu option. The following dialog displays:
  2. In the example above, the password password123 is used to access the repository.
  3. To connect Enterprise Architect to the repository, the user enters the encrypted password prefixed with $$, so the encrypted password becomes $$qcvtyrsf435.

For more information relating to connecting to Oracle and SQL Server, see the Connect to Oracle repository and Connect to SQL Server repository topics respectively.


  • Do not use the Test Connection button as it can cause an error with encrypted passwords.
  • For SQL Server repositories, you must enter the Initial Catalog details from the All tab of the Data Link Properties dialog.