English

How To: Create an SDE schema geodatabase using the Enable Enterprise Geodatabase geoprocessing tool in SQL Server

Summary

Using 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 the Esri Customer Care Portal.

Procedure

  1. Use an existing database or create a new database in SQL Server Management Studio.
  2. Create an SDE login (if not already in the instance) and map it to the database created in Step 1 to create the SDE user within the database.

    Note:
    When adding/mapping the login to the database as a user ensure that the username and default schema match.
    [O-Image]
    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.

  3. Open the properties for the database and explore the permissions page to grant the
    proper permissions for the SDE user.

    a. Create Function
    b. Create Procedure
    c. Create Table
    d. Create View
    e. View Database State
    f. View Definition
    [O-Image]
    Note:
    Use the script below to grant permissions to the SDE user for this newly-created database in SQL Server Management Studio:


    Code:
    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

  4. Make a connection in ArcCatalog to the newly created SQL Server database as the SDE user.
    [O-Image]
  5. Navigate to the Enable Enterprise Geodatabase geoprocessing tool and use the SDE connection and use the proper authorization file.
    [O-Image]
    Note:
    When connecting to a non-geodatabase, this tool can be accessed by right-clicking the database connection > Enable Geodatabase.
    [O-Image]
  6. All related the system tables, stored procedures, functions, and types are now owned by the SDE schema.
    [O-Image]

    [O-Image]

Related Information