Register ArcGIS Service Account as SQL Login & DB User

In order for the ArcGIS Enterprise system to communicate with the Enterprise Geodatabase via OS authentication, the service account running ArcGIS Enterprise must be added to the database.

As mentioned on the section's introduction page, we have already added the service account following the steps written on the 'Create SDE Account' page. As a brief refresher on creating OS accounts in the geodatabase, here are the general steps:

1. Launch SSMS as a 'superadmin'

   1. The 'superadmin' account can create new SQL Logins, hence why we are using it.

2. Expand the instance's 'Security' tree, navigate to 'Logins' and select the option to 'Add New Login.'

3. On the Add User dialogue, select the option for a 'Windows' or 'Operating System' account, which should offer the option to find & select the user. In our case, we are looking to add 'NEOM/enowagissrv'

   1. Note: when searching for AD users, be sure that the search dialogue is searching the 'Entire Catalog' to ensure your search isn't scoped incorrectly.

4. On the user creation dialogue, add the user to the newly created Enterprise Geodatabase, geodb with the database roles of 'db_reader' and 'db_writer.'

5. Create the user and validate the user appears in both the Security -> SQL Login section and the Database Security -> Users section

Now that we've added this account, ArcGIS Enterprise can leverage its service account to facilitate operating system mediated connections.