As part of InterDev’s MosaicGIS new client onboarding process, an enterprise geodatabase is created and registered with ArcGIS Server. This knowledge base entry address that process.
This knowledge base article is geared toward the GIS Systems Administrator for MosaicGIS.
Knowledge of ArcGIS for Server and SQL Server plus administrative access to the MosaicGIS platform.
SG-GIS-TS USERSsecurity group. If this user is assigned to a specific project, also request that three new security groups are created using the below schema. IT will create the groups while GIS will assign the appropriate permissions in SQL Server.
|Group Name||Description||SQL Permissions Needed|
||User may view data||db_datareader|
||User may edit existing datasets||db_datareader, db_datawriter, EXECUTE|
||User may create new datasets and edit existing datasets||db_datareader, db_datawriter, EXECUTE, CREATE TABLE, CREATE PROCEDURE, CREATE VIEW|
As the enterprise geodatabases on Mosaic use the Dbo schema, the user you’d like to own the database will need to create the database. To accomplish this, ask the user who will need to own the database to temporarily change their AD password and provide you with their login credentials.
Temporarily provide the database owner account with the
Create database via ArcGIS Pro or ArcMap. Creating the database using ArcGIS Pro makes it easier to obtain the connection file later, but ArcMap will work fine as well. the database name should follow the following schema, “
projectnameProjectsubcategoryGIS”. Note the use of camel case. An example is provided below.
Remove the database owner acount from the
Ask the database owner user to reset their password.
**DO NOT SKIP STEPS #5 or #6**
In SQL Server, add a new login under the
Security Folder. Locate the appropriate AD security group, noting that the object type field must be altered to include
Group and then location must be changed to
Interdev.com. If these parameters are not set, the security group will not be visible.
Once the group is selected, map it to the appropriate database. Configure permissions per the table below step #1. Ensure that the
Default Schema fields are the same.
Configure any other permissions necessary based on the table below step #1 by right-clicking the database in question, clicking properties, clicking on the
Permissions page, and finally selecting the security group that is being configured. There you will be able to make any changes needed. Once again, refer to the table below step #1 for specific permissions.
GISSQL\arcgis account to the new database within SQL Server and provide it with the
db_datawriter roles. This allows the database to be registered with the server using a connection file that contains AD credentials.
Export a connection file from ArcGIS Pro and register with ArcGIS Server via Server Manager.
Quality Control Checklist
If any of the above steps are not successful, please check that all steps in the procedure have been followed correctly.