Changing the passwords of the default logins

Four database login roles are provided with an enterprise geodatabase (EGDB) instance plus the Windows administrator login provided to you by ESRI support.

The database login role passwords are hard coded. Change them to make your instance more secure.

The Windows administrator login password is randomly generated. You received the decrypted password when you launched your instance. You can keep this password if you want. Most likely, though, you will want to change it to something you can more easily remember.

Steps:

1. Use Remote Desktop to connect to your EGDB instance server.
2. Change your Administrator password.
   1. Click Start > Administrative Tools > Computer Management.
   2. Expand Local Users and Groups > Users.
   3. Right-click the Administrator account and click Set Password.
   4. Click Proceed to dismiss the warning dialog box.
   5. Type the new password twice to confirm, then click OK.
Now you can change the passwords for the database login roles.
3. Open pgAdmin III.

   All Programs > PostgreSQL 8.3 > pgAdmin III

4. Double-click the localhost in the Object browser window.

   

5. Type postgres in the text box on the Connect to Server dialog box.
   Caution:

   Do not store the password since you are going to be changing it.

6. Click OK.
7. Expand the Login Roles listed under the localhost.
8. Right-click a role and click Properties.
9. Type a new password in the Password text box.
10. Confirm the new password by typing it in the Password (again) text box.
11. Click OK.
12. Repeat steps 8 through 10 for each role.
13. Exit pgAdmin III when you finish changing passwords.
    Tip:

    If you attempt to connect to the database or other objects on the PostgreSQL database cluster before you close pgAdmin III, the connection will fail because it doesn't recognize the new postgres password. If you need to work with any of the objects in pgAdmin III, close then restart the application.

Now you can make a connection from your ArcGIS Server instance to your EGDB instance.