Creating the product library geodatabase and setting up users in SQL Server Express (Production Mapping)

Creating a geodatabase

The server administrator needs to create an ArcSDE geodatabase for SQL Server Express licensed for ArcGIS for Server Workgroup or Desktop, which can be used as the product library.

Steps:

1. Log in as a server administrator, start ArcMap, then open the Catalog window.
2. In the Catalog tree, right-click the database server on which you want to create a new geodatabase.
3. Click New Geodatabase.
4. Type a name for the new geodatabase in the Geodatabase name text box.

   The name must begin with a letter, cannot contain spaces or special characters (such as *, &, !, %, ., +, or -), and have a maximum length of 31 characters when combined with your server name.

5. If you want to change the database file location, specify the new location in the Geodatabase file text box by clicking the ellipsis button (...) and browsing to the location.
6. Type the size of the new geodatabase in the Initial Size text box.
7. Choose MB or GB from the Units drop-down menu, or use the default size of 100 MB.

   Regardless of the initial size, the geodatabase grows as it needs to, up to 10 GB.

   Note:

   The initial size of the geodatabase cannot be smaller than that of the model database in the SQL Server Express instance. The model database is the system template for all new databases. The size of the model database determines the minimum size of any database created in that SQL Server Express instance. If you attempt to create a geodatabase smaller than this minimum size, database creation fails and the following error message is returned:

   Error creating this geodatabase
   CREATE DATABASE failed. 
   Primary file must be at least <size of model> to accommodate a copy 
   of the model database.

8. Click OK.

A progress bar displays while the database file and geodatabase schema are created. When complete, the new geodatabase appears on the Contents tab and in the Catalog tree.

Creating geodatabase users

The steps below are for creating users for the product library geodatabase in the Catalog window on a database server (an instance of SQL Server Express).

Steps:

1. Log in as a server administrator, start ArcMap, then open the Catalog window.
2. Right-click the database server to which you want to add a user or group.
3. Click Permissions.
4. Click Add user on the Permissions dialog box.
5. Specify the location where you want to search for the user or group.

   This can be the local machine or a domain.

6. Type the name of the user or group you want to add. You can click the Advanced button to do a more specific query to find the desired user.
7. Click Check Names to verify the login name is valid.
8. Click OK.

Granting geodatabase permissions

A role needs to be assigned to the users who are going to be working with the product library so they can view or add components, information, and data to the product library. These permissions are at the geodatabase level, assigned separately from the product library permissions. The roles are assigned through the Catalog window as permissions for users who are using a product library stored in SQL Server Express.

User names for the role are required for any users who are going to be working with the product library and need to read from or write to the product library tables and other components. The administrators are considered the owners of the data, so they already have this privilege.

The steps below are for granting roles/permissions on a database server (an instance of SQL Server Express).

Steps:

1. Right-click the geodatabase for which you want to grant user permissions.
2. Click Administration and click Permissions.
3. Choose the desired user or group from the list on the Permissions dialog box.
4. Click the appropriate role:
   • None—No specific access to the geodatabase or the datasets in the geodatabase has been granted.
   • Read Only—The user can only view and select data.
   • Read/Write—The user can read, write to, and create new datasets in a geodatabase or can read and write to an existing dataset.
   • Admin—The user can perform administrative tasks in a specific geodatabase.
   • Server administrator—This user manages the database server.
5. Click Apply.