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

【解决方案】
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.    
  When adding/mapping the login to the database as a user ensure that the username and default schema match.

 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 

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

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.

5.Navigate to the Enable Enterprise Geodatabase geoprocessing tool and use the SDE connection and use the proper authorization file.

When connecting to a non-geodatabase, this tool can be accessed by right-clicking the database connection > Enable Geodatabase.

6.All related the system tables, stored procedures, functions, and types are now owned by the SDE schema. 


【其它相关参考】

1. Enable Enterprise Geodatabase (Data Management)
2. User privileges for geodatabases in SQL Server

【创建及修改时间】
Created: 2/6/2014

Last Modified: 4/24/2014
【原文链接】
http://support.esri.com/en/kno ... 42212