Geodatabases in Amazon RDS for SQL Server

The ArcGIS Enterprise tools for Amazon Web Services provide options to include a geodatabase in Amazon Relational Database Service (RDS) for SQL Server. The geodatabase created by the tools is named egdb. ArcGIS Enterprise Cloud Builder Command Line Interface for Amazon Web Services, the ArcGIS Enterprise Cloud Builder for Amazon Web Services app, and the Esri AWS CloudFormation templates register the geodatabase with the ArcGIS Server site.

When you use Amazon RDS for SQL Server with ArcGIS software, connect using database-authenticated logins. The tools that create an ArcGIS GIS Server site create two SQL Server logins and database users when you choose to include an Amazon RDS for SQL Server instance with your deployment. The password for these logins is the same as the password you specified for the ArcGIS Server primary site administrator.

• EsriRDSAdmin—The EsriRDSAdmin user is the RDS master user, who creates the databases and sde user.

• sde—The sde user owns the geodatabase system objects and is considered the geodatabase administrator.

Amazon RDS for SQL Server instances created with the ArcGIS Enterprise tools for Amazon Web Services do not have mirroring enabled by default. If you require this functionality, you must manually enable it. See the Amazon Relational Database Service User Guide for more information.

Tip:

Once the geodatabase is created and registered with an ArcGIS Server site, you can move data into the geodatabase. When you publish services from this data or later delete these services, the data remains in the geodatabase.