Create a Database User

Now that the enterprise database is created, you need to create a new database user. The connected user must be the owner of the Utility Network (UN) and this user cannot have the DBO role.

Enterprise geodatabase user details:

1. Open the Geoprocessing pane, and enter Create Database User in the search bar. Open the tool.

2. Enter the required fields and click Run.

   • Drag the enterprise geodatabase name from the Catalog Pane > Databases to the Input Database Connection field on the Create Database User window.

   • Create Operating System Authenticated User box is unchecked by default. Leaving this box unchecked means that a database-authenticated user is created. Checking this box creates an operational system-authenticated user. This option requires that a corresponding operational system login already exist.

   • For Database User, enter the name of the database user you are creating.

   • For Database User Password, assign a password to the new user.

   • Role is optional.

   

3. Optionally, you can remove the existing database connection from the project. You are going to create a connection with the new database user login in the next steps.

   In the Catalog pane, under Databases, right click the current database connection and select Remove from Project.

4. Save your project, close, and reopen ArcGIS Pro.

5. Right click Databases and select New Database Connection.

   • Instance is the URL of the database server.

   • Authentication Type is Database authentication.

   • User Name is the new database user credentials.

   • Password is the new database user credentials.

     Make sure the Save User/Password box is enabled.

   • Database is the name of the database to which you want to connect. Select the name from the menu.

   • Connection File Name is automatically populated.

     

   The name of the database now has the user login in parentheses. Example: SQLServer-mydatabasename(fiber_user).sde where fiber_user is the name of the new database user.

6. Click Validate. Once Validate completes, click OK. If Validate is unsuccessful, work with your IT department to ensure you have the appropriate database connection properties, and appropriate permissions to create a new database user.