Skip To Content

Create an enterprise geodatabase in SQL Server Express on AWS

If you created an ArcGIS Enterprise on Amazon Web Services (AWS) instance using the Esri AMI that includes SQL Server Express and you are using an ArcGIS Server Enterprise license, you can create geodatabases using the Create Enterprise Geodatabase geoprocessing tool.


The Create Enterprise Geodatabase tool cannot be used to create a geodatabase in Amazon Relational Database Service (RDS) for SQL Server or a SQL Server Express instance licensed with ArcGIS Server workgroup edition. To create geodatabases (or additional geodatabases) in an Amazon RDS for SQL Server instance, see Create a geodatabase on Amazon Relational Database Service for SQL Server. To create geodatabases in a SQL Server Express instance licensed with ArcGIS Server workgroup, see Create additional workgroup geodatabases.

If you used ArcGIS Server Cloud Builder on Amazon Web Services to launch your instance, a geodatabase was included in the SQL Server Express instance. If you want additional geodatabases—for example, if you want to customize the name or location of the geodatabases you use, or you have multiple departments that maintain their own discrete data and require their own geodatabases—create additional geodatabases.

When you set up your site from Esri AMIs using the AWS Management Console, no geodatabases are created. If you want to use enterprise geodatabases in SQL Server Express with your ArcGIS Server site on Amazon Web Services (AWS), you must create them.

Follow these steps to create an enterprise geodatabase in a SQL Server Express instance on AWS and register it with your ArcGIS Server site:

  1. Make a remote desktop connection to your ArcGIS Server instance, logging in as the administrator.

    You must open the RDP port (3389) in your security group to do this.

  2. Start ArcMap and open the Catalog window or start ArcCatalog.
  3. Open the Create Enterprise Geodatabase tool.

    You can search for or browse to this tool, which is located in the Geodatabase Administration toolset of the Data Management toolbox.

  4. Choose SQL Server from the DBMS Type drop-down list.
  5. In the Instance text box, type or paste the public DNS of the instance where SQL Server is installed.
  6. In the Database text box, type a name for the database you want to create to contain your geodatabase.
  7. Check Operating System Authentication.
  8. Uncheck Sde Owned Schema.
  9. Browse to the keycodes file on the ArcGIS Server instance to populate the Authorization File text box.

    When you authorized ArcGIS Server, a keycodes file was written to Program Files\ESRI\License<release>\sysgen.

  10. Click OK to run the tool.

    If you encounter any errors, extended errors will be written to a log file (GDBCreateGeodatabase<#>.log), which is created in the directory specified for your %TEMP% variable on the computer where the tool is run.

    You now have a new geodatabase.

  11. Sign in to ArcGIS Server Manager for the ArcGIS Server site and register each geodatabase with the site.

    This ensures the services you publish have access to the data. For instructions on registering a database, see Register your data with ArcGIS Server using Manager in the ArcGIS Server help.

Related topics