Creating the NIS in an enterprise geodatabase in SQL Server (Maritime Charting)

This workflow provides steps for creating a geodatabase to use as the Nautical Information System (NIS).

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 NIS 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 NIS data owner login and database owner user and schema. Use NIS 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. You do not need to assign the NIS user to any SQL Server database-level role.

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 NIS;
GRANT CREATE TABLE To NIS;
GRANT CREATE VIEW To NIS;

Learn more about user privileges for geodatabases in SQL Server

Creating the user roles in the database

Create the following database roles in the NIS database using SQL Server Management Studio.

• CDR_EDITOR
• CDR_VIEWER

Leave the Owner field empty and do not check any of the Owned Schema options since these are not required for the CDR_EDITOR or CDR_VIEWER roles.

Database-authenticated and/or Windows-authenticated logins and users can be created as necessary in SQL Server Management Studio and assigned a database role membership in the CDR_EDITOR or CDR_VIEWER roles as needed. For example, you can create an NISEDITOR login, then create an NISEDITOR user and assign the NISEDITOR login to it. From there, you can add the NISEDITOR user to the CDR_EDITOR role. The same process can be used when creating and assigning an NISVIEWER user to the CDR_VIEWER role.

Preparing SQL Server to store ArcSDE XML columns

The NIS 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 NIS data owner 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 NIS 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 NIS 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 NIS 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 NIS database, and then 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.
• NIS—This is the NIS owner connection file with full privileges.
• NIS Edit Users—Connection files for NIS editors. They can only edit NIS features and attributes, but can’t delete the feature class or tables. These can be database-authenticated or Windows-authenticated connections, based on the users created in the previous step.

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