Creating the Nautical product library in an enterprise geodatabase in SQL Server (Maritime Charting)

This workflow provides steps for creating a geodatabase to use as a product library.

Creating the enterprise geodatabase

The Create Enterprise Geodatabase geoprocessing tool does the following:

• Creates a database on the SQL Server instance
• Creates sde login, user, and schema if sde geodatabase administrator is chosen
• Grants the geodatabase administrator privileges required to create a geodatabase
• Populates geodatabase system tables and stored procedures in the database
• Authorizes ArcSDE using the ArcGIS Server Enterprise license file

You must have a valid ArcGIS for Server authorization file (.ecp) to complete the geodatabase creation.

步骤:

1. 启动 ArcCatalog 或 ArcMap。
2. 打开创建企业级地理数据库 地理处理工具。

   在搜索 窗口中搜索工具，或直接从“数据库管理”工具箱的“地理数据库管理”工具集中打开工具的对话框。

3. 从数据库平台下拉列表中选择 SQL Server。
4. Type the <server_name>\<instance_name> in the Instance text box.
5. Type PL in the Database name text box.
6. Type the name of the user with sysadmin privileges, such as sa, in the Database Administrator text box.
7. Type the appropriate password in the Database Administrator Password text box.
8. Choose Sde Owned Schema.
9. 在地理数据库管理员密码文本框中输入地理数据库管理员的密码。

   如果数据库中已存在您指定的地理数据库管理员，请确保为现有用户输入正确的密码；此工具不会更改密码。

10. 要指定授权文件，请浏览到在授权 ArcGIS for Server Enterprise 时创建的密钥代码文件，并选择该文件。

    将此文件写入 Windows 服务器上的 \\Program Files\ESRI\License<release#>\sysgen 文件夹。如果尚未执行此操作，则立即授权 ArcGIS for Server 创建此文件。

11. 单击确定以运行工具。

Customizing ArcSDE initialization parameters

If users will connect to the enterprise geodatabase using an ArcSDE service, you need to configure the TCPKEEPALIVE ArcSDE initialization parameter to 1 (TRUE) in the sde.SDE_server_config table in the geodatabase. You can do this in SQL Server Management Studio.

Creating a database-authenticated login to the SQL Server instance

Create the product library data owner login, and database owner user and schema. Use PL for the login name, user name, and schema name. Note that user names for any accounts that own data must have the same name as their default schema.

Learn more about adding database-authenticated logins to a SQL Server database

Granting Data Owner privileges

Assign the following privileges to the users in the geodatabase using SQL Server Management Studio. Use the following SQL Transact code sample.

GRANT CREATE PROCEDURE To PL;
GRANT CREATE TABLE To PL;
GRANT CREATE VIEW To PL;

Learn more about user privileges for geodatabases in SQL Server

Creating the users role in the database

The CKB_USERS database role needs to be created in the geodatabase using SQL Server Management Studio.

Database-authenticated and/or Windows-authenticated logins and users can be created as necessary and assigned a database role membership in the CKB_USERS role as needed. For example, a PLEDITOR login and user can be created and assigned to the CKB_USERS role.

Preparing SQL Server to store ArcSDE XML columns

The product library data model includes ArcSDE XML columns as of version 10.1. Before an ArcSDE column can be created in a Microsoft SQL Server database, the database in which it will be stored must be enabled for full-text searching, a full-text catalog must be created, and permission to use the full-text catalog must be granted.

When you install SQL Server, be sure to install Full-Text Search. If you already created your database without this, you must add it. When a database is created using the CREATE DATABASE statement, it is automatically enabled for full-text searching.

You can create a full-text catalog in SQL Server and grant the appropriate privileges to the product library administrator user using SQL Server Management Studio.

步骤:

1. In SQL Server Management Studio’s Object Explorer, expand the appropriate SQL Server and expand Databases.
2. Right-click the product library database and click Properties.
3. Click Files in the Select a Page area on the left in the Database Properties dialog box.
4. Check the Use full-text indexing check box on the right if it is not already checked.
5. Click Permissions in Select a Page area on the left.
6. Click the product library user, which will own the XML column, in the Users or roles list in the page on the right.
7. In the Explicit permissions for the product library list at the bottom of the page, scroll down until you see the References permission.
8. In the row for the References permission, check the box in the Grant column.
9. Click OK in the Database Properties dialog box.
10. Expand the product library database and expand Storage.
11. Right-click Full Text Catalogs and click New Full-Text Catalog.
12. Type a name for the full-text catalog in the Full-text catalog name text box.

    If you provide a name other than SDE_DEFAULT_CAT, you must modify the value of the XML_IDX_FULLTEXT_CAT parameter for the DEFAULTS keyword in the SDE_dbtune table.

13. Click OK in the New Full-Text Catalog dialog box.

Learn more about preparing SQL Server to store ArcSDE XML columns

Learn more about creating a full-text catalog in SQL Server using Management Studio

Creating spatial database connection files

Create spatial database connection files for the following users.

• SDE—This connection file manages all geodatabase administration tasks.
• PL—This is the product library owner connection file with full privileges.
• PL Edit Users—Connection files for product library editors. They will have permission to do check in/out and edit the existing product nodes.

For the convenience of all other users, these connection files may be moved to a central location where they can be accessed.

Learn more about geodatabase connections in ArcGIS for Desktop