Create Database (SQL)

There are many options for enabling/creating and Enterprise Geodatabase, but only one is shown here. We used the ArcGIS Pro geoprocessing tool 'Create Enterprise Geodatabase' for the workflow.

Once the 'sde' account has been created, we can exit SSMS and launch ArcGIS Pro.

Once ArcGIS Pro is running, search for the 'Create Enterprise Geodatabase' geoprocessing tool. The tool's dialogue is shown directly below:

The tool is looking for eight (8) inputs. Those inputs and their corresponding values are reflected in the above picture, but are also listed below:

• Database Platform: SQL Server

• Instance: ENOWA-SGIS-DB

• Database: geodb

• Database Administrator: superadmin

• Database Administrator Password: ***

• SDE Owned Schema: True (checked)

• Geodatabase Administrator Password: **SDE_ACCOUNT_PASSWORD**

• Authorization File: \\ENOWA-SGIS-WPS\sysgen\keycodes

Note: the authorization file is a direct share of the GIS Server's keycodes (license) file. The Geodatabase is licensed via a valid ArcGIS Server license. Thus, as soon as the Sandbox server license expires, the geodatabase's license will likewise expire; and conversely, when the Sandbox server's license is updated/renewed, the geodatabase's license will likewise be updated/renewed automatically.