Connecting from an ArcGIS Server instance to an EGDB instance

Once you have deployed both ArcGIS Server and enterprise geodatabase (EGDB) instances and assigned new passwords to the default login roles, follow these steps to connect from your ArcGIS Server instance to your EGDB instance:

Steps:

1. Use Remote Desktop to log in to your ArcGIS Server instance server.
2. Start ArcCatalog (Start > All Programs > ArcGIS > ArcCatalog) on the ArcGIS Server instance server.
3. Expand the Database Connections node in the Catalog tree.

   

4. Double-click Add Spatial Database Connection.
5. Type the following connection properties to make a spatial database connection:

   Field	Value
   Server	Leave this field blank
   Service	The service connection string is sde:postgresql:<Public DNS name> The following is an example of a connection string: sde:postgresql:ec2-123-45-678-90.compute-1.amazonaws.com
   Database	The name of the geodatabase The default geodatabase is sdegdb.
   User	A database log in role For example: editor or reader Tip: Default login roles and passwords are listed in Enterprise geodatabase in Amazon.
   Password	The password for the login role

   Be sure you check Save username and password.

   The Spatial Database Connection dialog box should look similar to the following:

   

6. Click Test Connection to be sure the connection works.

   If it does not, double-check the information you provided, including the IP address in the service string. If it is correct, make sure the ArcGIS Server instance is running and that the correct port is open to connect to PostgreSQL.

7. Click OK to close the Spatial Database Connection dialog box.
8. Type a name for the connection.

   For example, ags1connection.

Note:

To publish a service that contains data from an enterprise geodatabase, you must place the .sde connection file in a location that the ArcGIS SOC account can access.