If you have a workgroup edition license and you use the ArcGIS Enterprise (Windows) Amazon Machine Image (AMI) to create a single-machine, stand-alone ArcGIS Server site, you can install, configure, and use a workgroup database server on the ArcGIS Server instance.
Creation and management of database servers and workgroup geodatabases are tied to ArcMap. Therefore, 10.8.1 is the latest release of database servers.
Install and configure a database server on Amazon Web Services
For the most part, installing and configuring a workgroup database server on Amazon Web Services (AWS) is the same as on-premises. The following is a summary of the steps you need to take:
- Make a remote desktop connection to the Amazon Elastic Compute Cloud (EC2) instance where ArcGIS Server is installed and authorize ArcGIS Desktop. See Administer your Amazon Elastic Compute Cloud instance with Windows Remote Desktop Connection for more information.
- Follow the instructions in the Database Server (Workgroup) installation guide to install the database server instance, enable it to store geodatabases, and create a geodatabase.
When connecting to the database server from an ArcMap installation on the ArcGIS Server EC2 instance, use localhost in place of the server name. On EC2, you are not limited to one specific server; therefore, you cannot specify a server name to connect to the SQL Server Express instance. Using localhost ensures that ArcGIS can find the SQL Server Express instance.
- Workgroup geodatabases use Windows authentication exclusively. Follow the instructions in AWS documentation to create logins on the EC2 instance.
- Add the logins to your database server and grant permissions for loading data.
See database server instructions in the ArcMap help.
- Place the new logins in the Windows Remote Desktop Users group to allow users to log in to the EC2 instance.
- Create a database connection file (.sde file) for each workgroup geodatabase you want to use for source data when publishing. Next, register each file with the ArcGIS Server site.
You cannot publish an ArcGIS Server web service from the Database Servers node (.gdb file) in the Catalog tree. Services must point to a database connection (.sde file).
As with all geodatabases on AWS, once the workgroup geodatabases exist, you need to load data into them.
See the topics in the Administering geodatabases on database servers section of the ArcMap help if you want to customize or directly administer workgroup geodatabases.