HOW TO
Note: ArcMap is in Mature support and will be retired March 1, 2026. There are no plans for future releases of ArcMap, and it is recommended that you migrate to ArcGIS Pro. See Migrate from ArcMap to ArcGIS Pro for more information.
The Enable Enterprise Geodatabase tool from ArcToolbox can take an existing database and create the geodatabase system tables, stored procedures, functions, and types within. This process allows the conversion of an enterprise database created in Microsoft SQL Server to an enterprise geodatabase for use with ArcGIS.
If there is a need to have the schema owned by the SDE user, the instructions provided describe the steps to set this up by setting up the SDE login/user within the database with proper permissions, and then making a connection to the database as the specific SDE user to implement the Enable Enterprise Geodatabase tool.
Note: The SQL Server DBMS client for the ArcGIS client must be installed to perform this process. The SQL Server DBMS client can be downloaded from My Esri.
Use an existing database or create a new database in SQL Server Management Studio.
Note: When adding/mapping the login to the database for the user, ensure that the username and default schema match.
Note: If the SDE login is not already created in the instance, be sure to add the Server Role of processadmin to the SDE login.
Note: Use the script below to grant permissions to the SDE user for this newly-created database in SQL Server Management Studio:
use [SQL Server Database Name] GO GRANT CREATE FUNCTION TO [sde] GO use [SQL Server Database Name] GO GRANT CREATE PROCEDURE TO [sde] GO use [SQL Server Database Name] GO GRANT CREATE TABLE TO [sde] GO use [SQL Server Database Name] GO GRANT CREATE VIEW TO [sde] GO use [SQL Server Database Name] GO GRANT VIEW DATABASE STATE TO [sde] GO use [SQL Server Database Name] GO GRANT VIEW DEFINITION TO [sde] GO
/arcgis/server/framework/runtime/.wine/drive_c/Program Files/ESRI/License<release>/sysgen
..\Program Files\ESRI\License<release>\sysgen
Note: When connecting to a non-geodatabase, this tool can be accessed by right-clicking the database connection, and clicking Enable Geodatabase.
All related the system tables, stored procedures, functions, and types are now owned by the SDE schema.
Get help from ArcGIS experts
Download the Esri Support App